Forum Discussion
Solved
selected value for multiple select
Hi All, what I need is if no region is selected in the region slicer then the measure need to show US region value for selected player i.e for player A if region is not selected then measure shou...
newbie9 , Use this measure that will give result on the basis of whether region is selected or not.
Measure 4 = IF(ISFILTERED(Table1[region]) , SWITCH(SELECTEDVALUE(Table1[player]),"a",CALCULATE(MAX(Table1[value]),Table1[player]="a"),"b",CALCULATE(MAX(Table1[value]),Table1[player]="b"),"c",CALCULATE(MAX(Table1[value]),Table1[player]="c")), CALCULATE(MAX(Table1[value]), Table1[region] = "us") )
newbie9 , Use this measure that will give result on the basis of whether region is selected or not.
Measure 4 = IF(ISFILTERED(Table1[region]) , SWITCH(
SELECTEDVALUE(Table1[player]),
"a",CALCULATE(MAX(Table1[value]),Table1[player]="a"),
"b",CALCULATE(MAX(Table1[value]),Table1[player]="b"),
"c",CALCULATE(MAX(Table1[value]),Table1[player]="c"))
, CALCULATE(MAX(Table1[value]), Table1[region] = "us") )
thanks ChiragGarg2512
now it's working as expected