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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
gco
Resolver II
Resolver II

Putting 2 measures on 1 column in a matrix

I have 2 different measures that are calculating SUM of columns of different tables.  And i wanted to display them in a matrix.

Is there a way to display these 2 different measures in a single line in a matrix?  The first screenshot below is how it looks like when i try to display them.  I tried renaming YTD1 to YTD, but PowerBI says the name already exists.

 

Matrix.PNG

 

 

This is what i am looking to do.

 

Matrix1.png

 

Thank you

Glen

1 ACCEPTED SOLUTION

Hi @Stachu ,

 

I was able to fix my problem by adding a new column that grouped the fields together.  I think i was just trying to make things complicated than what it is supposed to be.

 

All good now.  Thank you for replying.

 

Thank you

Glen

View solution in original post

2 REPLIES 2
Stachu
Community Champion
Community Champion

Can you add sample data tables (in format that can be copied to PowerBI) from your model with anonymised data? Like this (just copy and paste into the post window).

Column1Column2
A1
B2.5

 

you could add the measures together but that will change the total values - what do you need shown there?



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Hi @Stachu ,

 

I was able to fix my problem by adding a new column that grouped the fields together.  I think i was just trying to make things complicated than what it is supposed to be.

 

All good now.  Thank you for replying.

 

Thank you

Glen

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors