Using the total column from a Matrix

[hdemedici100]

Hi,

I've created a Matrix table like the below:

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!

[nandic · Accepted solution]

@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

[hdemedici100]

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