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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
MickOwl
Regular Visitor

Incorrect results whilst filtering - zero values

Hi

 

I have a simple table that has an ID column and the count of activities completed. The activity count is a measure in the FACT ACTIVITY TABLE. 

The table has a few page filters on it, such as status = yes, only certain types of activities selected which come from DIMENSION tables.

 

I have a SITE slicer, so I can see the list of ID's and what number of activities they have done, per site. So I can change the SITE slicer to SITE A - this then only shows me the ID's related to SITE A and so on. This works as it should if the value is 1 or above. But for anyone that has zero activities - I get the whole list of ID's - no matter which site I chose, when I get to zero's I get all the ID's for every site. Why is it working correctly for values 1 or above (site filter) but not for zero's!? We want to specifically see those on Zero.

 

Please help it is driving me crazy!

 

Thank you in advance

 

Michael 

 

 

2 REPLIES 2
MickOwl
Regular Visitor

Hi thanks for reply, sorry thought that might be the case.

 

Cant really upload a file its got all our companies information in it.

 

I have a table visual, and a slicer that has site field from another table. The slicer filters my table results by site when the value of my measure is 1 or above, but when the value is zero - it doesnt give me the zero's just for that site - it gives me zeros for the entire list of id's. I just want to see the zero's for the site I have picked in my slicer. The slicer works if the value is 1 or above (it filters the ID's by site). 

 

Thanks 

HotChilli
Super User
Super User

It's a bit difficult to work out what you are asking. Is this related to a table visual?

Can you show your model and some screenshots to explain your problem please?

--

If it's easier, post a link to your pbix and I'll have a look (This is the quickest solution)

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors