DAX to display measure values as per multiple values selected on a slicer

[Anonymous]

Hello brilliant community,

I need help to figure out how can I display measure values as per slicer selections: Here is my case-

'Category' is the report slicer.  If 'A' & 'B' are selected then measure 'Score of A& B' should display calculated values but 'Score of A&C' should display blank or zero. Similarly If 'A' & 'C' are selected then measure 'Score of A&C' should display calculated values but 'Score of A&B' should display blank or zero.

Category
A
B
C
Score of A & B	Score of A & C
5	8
6	9
7	0
23	10

Thanks in advance.

Meena

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

To create a measure as below.

Measure = var _sele = CONCATENATEX(category,category[Category],"&")
return
if(_sele="A&B",[Score of A & B],if(_sele = "A&C",[Score of A & C]))

Regards,

Frank

[Anonymous]

@v-frfei-msftworks perfectly!! Thanks heaps 

[Nishantjain]

Hi

Use the Switch function to create a new measure. Check the link below

https://www.fourmoo.com/2017/11/21/power-bi-using-a-slicer-to-show-different-measures/

Thanks

[Anonymous]

Thanks for the link @Nishantjain . It works if only one value is selected on the slicer,  my requirement is multiple values selection on the slicer. Any suggestions?

Thanks,

Meena