Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
bgarland
Helper I
Helper I

Count, Ignore Slicer

This should be really easy but I can't figure it out. I've got one card that shows a count of a column based on what is selected in a slicer, and another card that should show the count of the same column but ignoring the slicer (a total count in other words). But as you can see from these screenshots, the second card doesn't show the actual total count. I can't explain it.

 

This is a pivot of my data that shows the correct counts:

2018-08-23_111939.jpg

And here is are the two cards. The first, showing 408 is correct. That's just a simple COUNT, which respects the slicer selection. But I have no idea where the second card is getting a value of 13,295 when it should be ignoring the slicer and showing 14.037.

 

2018-08-23_111231.jpg

3 REPLIES 3
Greg_Deckler
Super User
Super User

What is the formula for your second measure? It should have an ALL in it. Like a COUNTX(ALL('Table'),[Column])



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

You should be able to see it in that screenshot, but here it is:

 

Total Count of JRS Lag = calculate(count('Product Rotation'[JRS Lag]), all('Product Rotation'[JRS Rotation Lag]))

Looks like we have a weird data issue and it's not a Power BI problem. Thanks for looking.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.