Forum Discussion
Aggregating values based on slicer selection
Hello, Been banging my head on an issue for a while now, and I'm new enough that I struggle to put it concisely (and hence search effectively). I am trying to build a dashboard where a user can ...
Ashish_Mathur
Super User
Super UserHi,
PBI file attached.
Hope this helps.
Hi,
The measure does exactly what I want within the table visual (as does the measure I listed in the post), but I can't find a way to use it outside the table visual--specifically, I need to use the dynamically calculated number of farms owned in a "between" slicer that will control which districts are higlighted on a filled map (that is, districts where the sum of farms owned falls between the minimum-maximum numbers specified in the slicer).
If I understand correctly, to make that work, the dynamic sum needs to be a table column rather than a measure--or can a measure be used independently in a slicer?
Thank you so much for your help!
Anton