Forum Discussion
Chicklet Slicer
I'm using the Chicklet Slicer to filter a set of data. There are other slicers that affect the number of rows contained in the Chicklet. What I'm trying to do its work out how to report the number of rows in the Chicklet so I can display it.
Thanks for any help.
North2Alaska ahh try this measure
Count Rows without Name Filter = Measure = CALCULATE( COUNTROWS ( 'Table' ), ALL ('Table'[Name] ) )
4 Replies
North2Alaska I guess you are trying to set rows dynamically in chicklet slicer, correct? I dont think that is possible, I could be wrong.
Well not quite. I have a table of collection with columns Name(and it is unique), Type as well as others. The Chicklet is the list of names and it is sent to require one to be selected so the table visualization is filtered for that one row. With another slicer on Type, the number of items in the Chicklet is reduced. When I get a count (and I've tried several ways) I either get 1 or 256 as the totall number of rows. What I want is the number of rows displayed by the Chicklet.
Another way to look at it is I want to count the number of rows filtered without the name filtered applied, even though it is.
North2Alaska ahh try this measure
Count Rows without Name Filter = Measure = CALCULATE( COUNTROWS ( 'Table' ), ALL ('Table'[Name] ) )
