Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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 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?

 

DAX1.PNGRelationship Power BI.PNG

1 ACCEPTED SOLUTION

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

 

lbendlin_0-1640723865500.png

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.

View solution in original post

4 REPLIES 4
zaraheyd
Frequent Visitor

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. 

lbendlin
Super User
Super User

Is your DAX measure overriding your data model filters?

Anonymous
Not applicable

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!

ratnak_0-1640583372510.png

 

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

 

lbendlin_0-1640723865500.png

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.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Find out what's new and trending in the Fabric Community.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.