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
------------------------------
Original Message:
Sent: Dec 14, 2022 08:20 AM
From: Krishna Nandan
Subject: Help in Slicer Conditional Measure
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.
Can anyone please help?
------------------------------
Krishna Nandan
SME
Bangalore
------------------------------