- 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
How do you display the total count of rows within each row of a matrix?
I am looking to create a matrix that looks like this.
The ID and Name fields have been selected from slicers. Now I need each row to display the total number of selected rows.
ID | Name | Total Rows |
12 | AB | 4 |
34 | CD | 4 |
56 | EF | 4 |
78 | GH | 4 |
This seems very simple. But any way I try to remove keep/remove context filters, the Total Rows just displays 1.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @AABright ,
I’d like to acknowledge the valuable input provided by the @lbendlin . Their initial ideas were instrumental in guiding my approach. However, I noticed that further details were needed to fully understand the issue.
In my investigation, I took the following steps:
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:
Create a measure
Total Rows = CALCULATE(COUNTROWS(VALUES('Table'[ID])), ALLSELECTED('Table'))
Final output
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @AABright ,
I’d like to acknowledge the valuable input provided by the @lbendlin . Their initial ideas were instrumental in guiding my approach. However, I noticed that further details were needed to fully understand the issue.
In my investigation, I took the following steps:
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:
Create a measure
Total Rows = CALCULATE(COUNTROWS(VALUES('Table'[ID])), ALLSELECTED('Table'))
Final output
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try ALLSELECTED()
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
OK, if that's what you want 🙂 See my sample.
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @AABright , If you have a single table and looking to create a DAX measure to count rows for selected values from a slicer you can simply use something like this.
Total Rows = COUNTROWS(TableName)
For your specific question, please share your datamodel or sample data to be able to help you further. See this post.
How to Get Your Question Answered Quickly - Microsoft Fabric Community
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you for the suggestion @amustafa
That produced the same result where the level of detail is applied to each row in the matrix - so it just counts 1.
In a card it displays the correct number. But I am trying to get 397 into each row, rather than 1.
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
07-11-2024 08:35 AM | |||
08-13-2024 10:02 AM | |||
07-01-2024 08:04 AM | |||
Anonymous
| 10-27-2023 10:21 AM | ||
06-28-2024 05:00 AM |
User | Count |
---|---|
21 | |
17 | |
12 | |
6 | |
5 |
User | Count |
---|---|
29 | |
25 | |
20 | |
13 | |
10 |