topic Re: How to count no. of items within a subgroup? in DAX Commands and Tips

How to count no. of items within a subgroup?

AdityaG — Sat, 20 May 2023 06:42:56 GMT

Hi all,

Need a dynamic DAX that can count the no. of items within a category. Following is a sample data:

Result should be something like this:

Please don't assume that A,B,C are the only Level 1s, as it might change as new data comes in.

The same DAX should work for following change as well (Let's say a 4th Level 1 comes in)

The result should then be:

FreemanZ — Sat, 20 May 2023 07:06:52 GMT

try to plot a table visual with level1 column and a measure like:

count = COUNTROWS(data)

it worked like:

FreemanZ — Sat, 20 May 2023 07:08:26 GMT

or you create a calculated table like:

table =

ADDCOLUMNS(

VALUES(data[level 1]),

"Count",

CALCULATE(COUNTROWS(data))

)

AdityaG — Sat, 20 May 2023 07:24:50 GMT

Thanks! This helps.

AdityaG — Sat, 20 May 2023 07:26:40 GMT

I needed just like your 1st solution (which I've accepted), of adding a measured column to the table.