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") )
yes that's it
when no region is selected for A then 100
if all regions are selected then 300
if us & uk is selected then 200
if uk & India is selected then 300
if uk alone then 200
if us alone then 100
no region is selected it should give show value of US region if not MAX of selected regions
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