topic Re: distinct count of occurence by category in DAX Commands and Tips

distinct count of occurence by category

DagmaraG — Wed, 08 Mar 2023 13:35:20 GMT

Hi!

I have table with

Product and Value fields

I need to count nr of products which have more then 9 occurences of Values.

I tried this measure, but I guess its different contex.

CALCULATE(DISTINCTCOUNT(Table[Product]), FILTER(Table, DISTINCTCOUNT(Value) > 9))

FreemanZ — Wed, 08 Mar 2023 13:49:39 GMT

try like:

Measure =

VAR _table =

ADDCOLUMNS(

VALUES(TableName[Product]),

"Count",

CALCULATE(COUNTROWS(TableName))

)

RETURN

COUNTROWS(

FILTER(

_table,

[Count]>9

)

v-zhangti — Mon, 13 Mar 2023 06:22:21 GMT

You can try the following methods.

Measure:

Count1 = COUNT('Table'[Product])

Count2 = CALCULATE(DISTINCTCOUNT('Table'[Product]),FILTER(ALL('Table'),[Count1]>=9))

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.