Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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...
Need Help
v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Do you have any other suggestions of things I can try?

     

    Thanks!