Forum Discussion
Unexpected Behaviour in Click to Filter
Hi All, I have a matrix visual that I am using to show help desk ticketing data. Across the rows I have the ticket category, and across the columns I have various measures (met SLA, missed SLA, ...
pbiuser12345 , if there is a filter in measure, that will not pass other visual (Drill Across or drill down). So the other visual need have that measure (Some time only that measure or that measure as visual level filter) to show you the correct number of records
That is actually the situation here - the measures are either doing a COUNX with a FILTER inside, or they are secondary measures referring to the COUNTX/FILTER ones.
I tried adding the measures all as visual-level filters but it unfortunately didn't fix the issue. Is there another way this can be avoided?
Are there ways to structure your measure so that this effect doesn't happen (i.e. would it matter if I used CALCULATE vs a COUNTX/FILTER structure)?