Forum Discussion
Aggregating values based on slicer selection
Hi,
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
You are welcome. It loks like your ultimate objective is to create a slicer of the "Sum by size" column. Do you want the slicer to have individual figures or buckets i.e. 0-20, 21-40 etc? If you want buckets, then please specify what those buckets should be?
Hi Ashish Mathur,
I am looking for a slicer on individual figures, pretty much what I have on the screenshot below, but with the option to specify which size category farms should be considered for selection.
Thanks again,
Anton