Power BI Exchange

View Only

Help in Slicer Conditional Measure

• 1.  Help in Slicer Conditional Measure

Silver Contributor
Posted Dec 14, 2022 08:20 AM
Hi , I have a requirement where i have two slicer - one is monthly and other is Market, where i have to make a measure to show data in a card based on the selection from both the slicers. For example - if i have selected Sep-2022, and Market EU then EU = 22.45% shall come if selected NA - 22.55%, GM - 23.3% like that it should come and if i select the different month then EU/GM/NA value shall change.

if(SELECTEDVALUE('Calendar'[Month Year]) = "Sep-2022" , if( SELECTEDVALUE('myWizard Project'[Market 2]) = "EU", "26.82%",if(SELECTEDVALUE('myWizard Project'[Market 2]) = "NA", "34.12%", IF(SELECTEDVALUE('myWizard Project'[Market 2]) = "GM", "22.50%")))), "29.49%")
but this formula gives blank.

------------------------------
Krishna Nandan
SME
Bangalore
------------------------------

• 2.  RE: Help in Slicer Conditional Measure

Posted Dec 14, 2022 11:44 AM

Veja se dá certo. Se não der, envia seu pbix por favor. Pode ser com dados fictícios.

``````Medida =
VAR Var1 = SELECTEDVALUE ( 'Calendar'[Month Year] )
VAR Var2 = SELECTEDVALUE ( 'myWizard Project'[Market 2] )
RETURN
SWITCH (
TRUE (),
Var1 = "Sep-2022" && Var2 = "EU", "26.82%",
Var1 = "Sep-2022" && Var2 = "NA", "34.12%",
Var1 = "Sep-2022" && Var2 = "GM", "22.50%",
"29.49%"
)​``````

------------------------------
Vilmar Santos
------------------------------