cancel
Showing results 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

New Member

## Matrix visual behavior difference ...

I'm trying to understand a difference in how a matrix is behaving. I think the easiest way is to show with a small example.

Here is a sample table that I am using. Row/Sensor combinations with values for each combo:

I create a measure for average value on this table by filtering using the sensor column:

This produces the following matrix:

This was what I was expecting, I am seeing every row/sensor combination in the matrix but the value is restricted to only averaging those rows in the table with a sensor value of 1.

However, I changed the measure to the following:

This change resulted in the following changes to the matrix visual:

I was expecting that even though the measure is using a different column to filter on that I would still see every row/sensor combination from the original table displayed in the matrix. However, those row/sensor combinations that don't meet the filter criteria in the measure are now not being displayed in the matrix. There are no other filters applied to the matrix visual.

Why is the matrix not showing all of the row/sensor combinations when the second version of the measure is being used? I understand that the value being calculated would not necesarrily be meaningful data for all of the combinations, but shouldn't every combination still appear in the visual (similar to version 1 of the measure)?

Thanks!

2 REPLIES 2
Super User

@jp222  I believe this is due to the filter context and the fact that you're using the Value column both in the Average and in the filter.

Try:

Sensor 3 = CALCULATE ( CALCULATE( AVERAGE[ Table[Value]) ), Table[Value] = 10)

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

New Member

It looked like the average function was missing an opening parenthesis in the modified formula. I added that in but it did not change the visual. The matrix still shows only a subset of the row/sensor combinations as if the measure itself is filtering what is shown on the visual.

Thanks.

Announcements

#### 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 Monthly Update - June 2024

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

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors