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
jp222
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:

 

SampleData.jpg

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

PBI-measure1.jpg

 

This produces the following matrix:

PBI-Matrix1.jpg

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:

PBI-measure2.jpg

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

PBI-Matrix2.jpg

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
AllisonKennedy
Super User
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) 


Please @mention me in your reply if you want a response.

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.
If you found this post helpful, please give Kudos C

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

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.

Helpful resources

Announcements
Europe Fabric Conference

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

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

Top Solution Authors