Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
Solved! Go to Solution.
@North2Alaska ahh try this measure
Count Rows without Name Filter =
Measure = CALCULATE( COUNTROWS ( 'Table' ), ALL ('Table'[Name] ) )
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@North2Alaska I guess you are trying to set rows dynamically in chicklet slicer, correct? I dont think that is possible, I could be wrong.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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] ) )
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Perfect! That worked. 🙂
Seems simple with the answer, but I just couldn't wrap my head around it...
Thank you for the help....
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 133 | |
| 88 | |
| 85 | |
| 68 | |
| 64 |