Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |