Forum Discussion
Filtering not working when selecting one visualization but filters when others are selected
Hi,
On a report I'm working on I'm running into a strange issue with filtering. In the screenshot you can see when I click "Phone In" it filters the Student and Faculty/Staff visualization. But when I click "Faculty/Staff" it doesn't filter that "Phone In" section.
What would cause this? The Faculty/Staff visualization is made up of 2 measures for the values. That's the only thing I can think of that's different. I have many other visualization that all work properly like the "Phone In" one.
Thanks!
3 Replies
Hi Anonymous ,
Based on my test, it could work on my side:
Could you have checked if there is any relationships between the two visuals? And you could copy your visual and turn them into tables to see the data changes like the picture above.
Also you could share your file that I could test for you.
Regards,
Daniel He
Hi v-danhe-msft,
Sorry I can't share the file because of sensitive data.
All the data is in the same table so I don't think it's a relationship issue.
When putting the visual in table I get the same result with the filtering.
My measures are:
_Not SharePoint User = CALCULATE( COUNTA('Cases'[Not a Sharepoint_x00]), 'Cases'[Not a Sharepoint_x00] IN { "TRUE" } )_Cases Minus SP = [_Total Cases] - [_Not SharePoint User]
_Total Cases = COUNT('Cases'[Id])All 3 measures are formatted as "Whole Number".
Thanks
