Forum Discussion

North2Alaska's avatar
North2Alaska
New Member
6 years ago
Solved

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 ...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    North2Alaska ahh try this measure

     

    Count Rows without Name Filter = 
Measure = CALCULATE( COUNTROWS ( 'Table' ), ALL ('Table'[Name] ) )

     

parry2k's avatar
parry2k
Super User
6 years ago

North2Alaska I guess you are trying to set rows dynamically in chicklet slicer, correct? I dont think that is possible, I could be wrong.

  • North2Alaska's avatar
    North2Alaska
    New Member
    6 years ago

    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.

    • parry2k's avatar
      parry2k
      Super User
      6 years ago

      North2Alaska ahh try this measure

       

      Count Rows without Name Filter = 
Measure = CALCULATE( COUNTROWS ( 'Table' ), ALL ('Table'[Name] ) )

       

      • North2Alaska's avatar
        North2Alaska
        New Member
        6 years ago

        Perfect!  That worked.  ğŸ™‚

        Seems simple with the answer, but I just couldn't wrap my head around it...

         

        Thank you for the help....