- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Using the total column from a Matrix
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!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-29-2024 03:00 PM | |||
04-23-2024 10:16 AM | |||
12-29-2022 03:25 PM | |||
12-01-2023 06:38 AM | |||
11-22-2023 06:01 AM |
User | Count |
---|---|
102 | |
84 | |
81 | |
53 | |
46 |