March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
89 | |
86 | |
77 | |
49 |
User | Count |
---|---|
164 | |
149 | |
101 | |
73 | |
56 |