Forum Discussion

ant_lah's avatar
ant_lah
Frequent Visitor
1 year ago

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 ...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
1 year ago

Hi,

Based on the table that you have shared, show the expected result very clearly.

  • ant_lah's avatar
    ant_lah
    Frequent Visitor
    1 year ago

    Good point--edited the original post with examples. Thanks!

      • ant_lah's avatar
        ant_lah
        Frequent Visitor
        1 year ago

        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