Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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
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
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