topic Re: Count number of specific categories in DAX Commands and Tips

Count number of specific categories

Anonymous — Mon, 09 Aug 2021 14:38:08 GMT

Hi,

If I have the dataset below and want to find out the amount of categories with 2 or less IDs belonging, how do I do this.
I have found the total amount of categories (in this example, num_cat = 4), but I struggle to find the number of categories with 2 or less IDs connected to it.

Num_cat_less_than_2 = 2 because only category C and D has less than 2 IDs connected to them.

Re: Count number of specific categories

Samarth_18 — Mon, 09 Aug 2021 14:58:43 GMT

Hi Anonymous ,

You can add both your column in table visual and take distinct of your ID column

and now select filter as below:-

Thanks,

Samarth

Re: Count number of specific categories

Anonymous — Mon, 09 Aug 2021 15:02:59 GMT

Thank you! I forgot to specify that I need to formulate this in DAX, not as a visualization.

Re: Count number of specific categories

Jihwan_Kim — Mon, 09 Aug 2021 15:15:23 GMT

Num_Cat_Less_Than_2 : =
COUNTROWS (
FILTER (
ADDCOLUMNS (
VALUES ( 'Table'[Category] ),
"idcount", CALCULATE ( COUNTROWS ( 'Table' ) )
),
[idcount] < 2
)
)