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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
hdaoued
Frequent Visitor

Measure added to a Matrix shown multiple times

Hi,

 

I am showing in a Matrix the percentage of the valid supplier certificates (green + yellow against red) per center and i would like to show this only in the total section. The problem is that the measure is dispalyed and showing the same info multiple times (per Certificate status) as you can see it in the screen shot. How to remove the columns which i highlighted in red and keep only the one which i highlighted in green?Issue_Matrix.jpg

1 ACCEPTED SOLUTION
goncalogeraldes
Super User
Super User

Hi @hdaoued ! Whenever you add a measure to the values box in a visual, Power BI always computes it for every available column (filtering context) and, to my knowledge, there is no way to customize or choose in which columns the measure will be computed. The work around I would do, would be something in the lines of:

 

1. In your "% of valid certificates" measures add a SWITCH() to show blank values in all rows except the total column (for example in my case I did it like this)

 

Avg Unit Price = 
SWITCH(
    TRUE(),
    HASONEVALUE('Calendar'[Year]), BLANK(),
    AVERAGE( Orders[UnitPrice] )
)

 

2. Go to the formatting pane of the visual -> Values -> Options -> Switch values to rows rather than columns

 

goncalogeraldes_0-1671012608906.png

3. The end result will look something like this!

 

goncalogeraldes_1-1671012693874.png

 

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

View solution in original post

2 REPLIES 2
hdaoued
Frequent Visitor

@goncalogeraldes Thanks! Problem solved as per your suggestion 🙂

 

goncalogeraldes
Super User
Super User

Hi @hdaoued ! Whenever you add a measure to the values box in a visual, Power BI always computes it for every available column (filtering context) and, to my knowledge, there is no way to customize or choose in which columns the measure will be computed. The work around I would do, would be something in the lines of:

 

1. In your "% of valid certificates" measures add a SWITCH() to show blank values in all rows except the total column (for example in my case I did it like this)

 

Avg Unit Price = 
SWITCH(
    TRUE(),
    HASONEVALUE('Calendar'[Year]), BLANK(),
    AVERAGE( Orders[UnitPrice] )
)

 

2. Go to the formatting pane of the visual -> Values -> Options -> Switch values to rows rather than columns

 

goncalogeraldes_0-1671012608906.png

3. The end result will look something like this!

 

goncalogeraldes_1-1671012693874.png

 

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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