Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hey Everyone,
Hope you're well. I am trying to create a measure which returns the sum of "count" only when I select a specifc value in the slicer.
For example:
I am trying to create a measure which will return the sum of "count" column only when Apple is selected. If any other value is selected it should return 0. Any help is appreciated.
Thanks!
Solved! Go to Solution.
@akkitek Measure = IF(SELECTEDVALUE('Slicer'[Fruits])="Apple",SUM('Table'[Count]),0)
@akkitek Measure = IF(SELECTEDVALUE('Slicer'[Fruits])="Apple",SUM('Table'[Count]),0)
Thanks! This worked perfectly!
User | Count |
---|---|
87 | |
84 | |
70 | |
62 | |
56 |
User | Count |
---|---|
137 | |
110 | |
92 | |
84 | |
69 |