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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
PrivateAnalytic
Helper IV
Helper IV

Trying to get filters to work together but am having issues

Hello everyone! 

I have a table created with amazing information over people's performances on spams. I also have some slicers created for users to drill down between specific things. Such as the company they work for, the date a spam was sent, the specific title of a spammed message, and the amount of times a person clicked on the spammed message. All of the slicers work on the table... however for some reason they do not all work together. The only slicer that doesn't work dynamically is the click count slicer. The click count slicer only works correctly if no other slicer is used. Is there a way I can get them all to work together?

PrivateAnalytic_0-1660586328721.png

 

4 REPLIES 4
jamilqpr
Frequent Visitor

I think you using a count slicer. My Advice to you is that you can use count distinct as value count then your problem will be solved

This is what the field is for the slicer. Is it possible to like fix this???

PrivateAnalytic_0-1660588001867.png

 

Distinctcount ( )

One thing though with Distinct Count in my case is it is based off of Yes and No Answers. So the distinct count here would be 3 for everyone. Unless a person didn't receive one which would be blank.

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.