topic Re: Applied Filter but Matrix Report Still Shows All Data in Custom Visuals Development Discussion

Applied Filter but Matrix Report Still Shows All Data

Anonymous — Fri, 24 Dec 2021 06:43:13 GMT

Hi,

I applied a filter but the one of the matrix columns still shows all data (there is a DAX measure) instead of the filtered one hwile the other one works fine (no DAX measure). On the left matrix column, the filter works on the measure DAX for but still shows all data (showing all 100%).

Could anyone please advise what went wrong here?

Re: Applied Filter but Matrix Report Still Shows All Data

lbendlin — Sat, 25 Dec 2021 19:37:38 GMT

Is your DAX measure overriding your data model filters?

Re: Applied Filter but Matrix Report Still Shows All Data

Anonymous — Mon, 27 Dec 2021 08:42:35 GMT

Thanks lbendlin.

I am not too sure if my DAX measure overides the data model filter. I did a research and still couldnt find out why, i thought DAX is supposed to be dynamics.

Below is my DAX. Here is the link to the files, https://drive.google.com/drive/folders/1RnHae0iu8atjK5ao3t4YbDVC6C570GFu?usp=sharing.

Could you please help to take a look what goes wrong? Million thanks!

Re: Applied Filter but Matrix Report Still Shows All Data

lbendlin — Tue, 28 Dec 2021 20:39:07 GMT

You can observe that the issue "goes away" when you remove the measure

So yes, your measure definition overrides the data model. Your data model can also be improved/normalized. I would recommend you separate out the geography dimension from the role dimension.

Re: Applied Filter but Matrix Report Still Shows All Data

Anonymous — Fri, 12 May 2023 05:16:52 GMT

Hi ratak,

I don't think it is your measure override the filter. I experienced the same issue and replaced my measure (which was a simple average) with the column itself and set it to show the average. This did not resolved . But once I filtered out in transformation , this time the filtered was applied.