Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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!