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
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!