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
Hi guys,
I am stucked with one very simple logic of DAX.
I have a small table:
I created two very simple measures as you can see below:
Measure for column values:
the issue is that once i select single values in slicer, it works fine but once i select A or B & C together it is showing blank.
i am not sure if i am trying to do something in power bi which is not possibile.
any suggestions will be really helpful for me.
Thanks
Solved! Go to Solution.
@TaroGulati , try like
value column = SWITCH(true() ,
"A" in allselected('Table'[Category]),10,
"B" in allselected('Table'[Category]),20)
Measure for Line values:
Value Line = SWITCH(true() ,
"C" in allselected('Table'[Category]),30)
First one is using switch, not the best option if both A and B are selected
@TaroGulati , try like
value column = SWITCH(true() ,
"A" in allselected('Table'[Category]),10,
"B" in allselected('Table'[Category]),20)
Measure for Line values:
Value Line = SWITCH(true() ,
"C" in allselected('Table'[Category]),30)
First one is using switch, not the best option if both A and B are selected
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
124 | |
89 | |
84 | |
70 | |
51 |
User | Count |
---|---|
206 | |
146 | |
97 | |
79 | |
69 |