topic Re: How do you display the total count of rows within each row of a matrix? in DAX Commands and Tips

How do you display the total count of rows within each row of a matrix?

AABright — Wed, 03 Apr 2024 18:43:19 GMT

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.

Re: How do you display the total count of rows within each row of a matrix?

amustafa — Wed, 03 Apr 2024 20:59:58 GMT

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

Re: How do you display the total count of rows within each row of a matrix?

AABright — Wed, 03 Apr 2024 21:11:43 GMT

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.

Re: How do you display the total count of rows within each row of a matrix?

amustafa — Wed, 03 Apr 2024 21:22:21 GMT

OK, if that's what you want 🙂 See my sample.

Total Rows Count = CALCULATE(COUNTROWS(financials), ALL(financials))

Re: How do you display the total count of rows within each row of a matrix?

lbendlin — Wed, 03 Apr 2024 21:34:22 GMT

Try ALLSELECTED()

Re: How do you display the total count of rows within each row of a matrix?

Anonymous — Thu, 04 Apr 2024 02:29:10 GMT

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