Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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