I am using DimensionA as a visual filter on my page, then I am using the same dimension in my matrix.
I am using a measure to control that at least one value has been filtered from my filter. I use the ISFILTERED Function, which works fine outside the matrix, but inside the matrix no.
the measure is like that:
measure = IF(ISFILTERED(DimensionA),CALCULATE(SUM(Fact(colA))),Blank())
So outside the matrix works fine, but inside the matrix, the measure is just showing data whatever is my selection.
Any idea on how to control what is filtered outside the matrix?
Many thanks!