This content has been marked as final.
Show 1 reply
-
1. Re: In calculation detect if all filters are all selected
Joe OppeltJan 11, 2019 12:11 PM (in response to stephen conard)
I make two calcs (per dimension).
You have the FIXED concept right.
{ FIXED : COUNTD([dimension name]) } // gives you count in the data source.
I test what is on the sheet like this:
{ EXCLUDE [dimension1] (, [dimension2], [dimension-N]) : COUNTD([dimension name]) }
... where the list of dimensions includes all the dimensions that are used on the sheet.
Yes, you can nest them all into one giant calc. I like to compartmentalize them into separate calcs. That's just my preferred method.