Matrix - Do not display values if no filter selected (issue)

[RyanHare92]

Hi,

I've used this method many times before to not display data if no filters are selected, but for some reason it doesn't seem to be working with a matrix I have createad.

I have a filter control called: 

Filter Control 2 = if(OR(ISFILTERED(Entries[syll_comp]), ISFILTERED(CalculatedTable[Syll_Comp])),1,0)

And then on the following Matrix I applied the filter control 2 to the filters to only show values if = 1.

The idea here is that, if no filters are selected in entries or calculatedtable for syll_comp, then it shouldn't show any data. The reason for this is that it would calculate a combination of an impossible amount of values if it tried to display every match and it always displays an error.

The issue I'm having is that this is not working. Even with though I can check that Filter Control 2 is working, even when returning 0 it keeps trying to calculate all matches in the Matrix, which causes an eternal spinning wheel.


Any help or explanation as to why this is happening would be helpful. Like I said, I've done this before with many other visual types and it has always worked, but apparently not with a Matrix.

[Anonymous]

Hi @RyanHare92,

If you do not want to calculate on these not match records, I'd like to suggest you write a measure formula to replace the raw value field on matrix with if statement and these filter conditions. They should check on the filter status and skip the calculation on not matched ranges.

Regards,

Xiaoxin Sheng