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.
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!
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |