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
danextian's avatar
danextian
Super User
1 year ago

Hi ant_lah 

Try the following:

farms by district and state = 
CALCULATE (
    SUM ( 'Table'[number of farms owned] ),
    ALLEXCEPT ( 'Table', 'Table'[District], 'Table'[state] )
)

 

 

 

ant_lah's avatar
ant_lah
Frequent Visitor
1 year ago

Hi danextian ,

Your proposal correctly sums the values over state and district, but it sums all of the size categories regardless of which of them I have selected in a slicer. Am I missing something?

 

Thanks!

Anton