Reply
hdemedici100
Frequent Visitor
Partially syndicated - Outbound

Using the total column from a Matrix

Hi,

I've created a Matrix table like the below:

hdemedici100_0-1716414114384.png

 

For the total column marked in red, is it possible to use these figures in another table?

 

I want to take these figures, and then do a count of how many are showing:

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6-10
  • 11-50
  • 51-100
  • 101+

Thanks in advanced!

1 ACCEPTED SOLUTION
nandic
Super User
Super User

Syndicated - Outbound

@hdemedici100 totals are just presented on this visual, they are not physically stored anywhere. If you group data by some other column, these totals will be different.

In order to make it work, you would need to create table in expected format (columns used in rows + measure). You can make it using summarize function in dax, or to use GroupBy option in Power Query.

And then add new column using if or switch statement which says in which range each row fits.
Then it is easy to show results in visual.

Cheers,
Nemanja Andic

View solution in original post

2 REPLIES 2
nandic
Super User
Super User

Syndicated - Outbound

@hdemedici100 totals are just presented on this visual, they are not physically stored anywhere. If you group data by some other column, these totals will be different.

In order to make it work, you would need to create table in expected format (columns used in rows + measure). You can make it using summarize function in dax, or to use GroupBy option in Power Query.

And then add new column using if or switch statement which says in which range each row fits.
Then it is easy to show results in visual.

Cheers,
Nemanja Andic

Syndicated - Outbound

Hi Nemanja,

 

Thanks very much for responding and for explaining. I didn't realise this was the case with the Matrix visual. 

 

I'll look to reproduce it in a new table, and see how I get on. If I get stuck, I'll come back to this forum.

 

Harry

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)