Measure filters matrix rows based on the sum the row, instead of columns indivdually

[Anonymous]

Hi

I have a problem with filtering my matrix propperly.

I have built the following measure:

Measure + Q3 and Q4

In the picture above My measure can be seen. It produces the bottom matrix, and has the value 1 if allocations are greater than capacity in the given time period, and 2 if capacity is greater than the allocations.

I want to filter my matrix (the top one with colors) so that if at any time column allocations are greater than capacity for a role, all columns for the given role are shown.

However, my measure is not working correctly. 

Values for Q3Values for Q4

The above two pictures shows the values for specific roles for Q3 and Q4 2022. It can be noticed here that the role "Operational Indkøber" Is filtered out in the first picture of this post where both Q3 and Q4 is chosen.

I believe its due to the measure is calculating row based instead of columns based.

The data model can be seen here:

Cheers

[v-jianboli-msft]

Hi @Anonymous ,

According to my knowledge, it is caused by your slicer. You may need to modify your measure to make sure it won't change when the slicer is changed, or use calculated columns instead of measure. 

If you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.