Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Applied Filter but Matrix Report Still Shows All Data

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 ma...
  • lbendlin's avatar
    lbendlin
    4 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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!

 

lbendlin's avatar
lbendlin
Super User
4 years ago

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.