Forum Discussion
Aggregating values based on slicer selection
Hi,
Based on the table that you have shared, show the expected result very clearly.
Good point--edited the original post with examples. Thanks!
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?