Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
This is what i am looking to do.
Thank you
Glen
Solved! Go to 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
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).
Column1 | Column2 |
A | 1 |
B | 2.5 |
you could add the measures together but that will change the total values - what do you need shown there?
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