Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello Community,
I am trying to use a Slicer to filter for Sales by location.
I am not able to select the measure, is there a way for this?
Measure - Sales by Location = CALCULATE(SUM(Sales[salesTotal]),Filter(ALL(Sales[location]),Sales[location] in Values(Sales[location])))
Regards,
Krish
you cannot directly use a slicer to filter a measure in visualizations. Slicers are typically used to filter dimensions or categorical fields in your data, rather than measures.
If I correctly understand, if your data has the location column you can use it directly to filter sales by location.
or you can create a calculated column and then use it with filter visual
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |