distinct count of occurence by category

[DagmaraG]

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 · Accepted solution]

hi @DagmaraG 

try like:

Measure =

VAR _table =

ADDCOLUMNS(

    VALUES(TableName[Product]),

    "Count",

     CALCULATE(COUNTROWS(TableName))

)

RETURN

COUNTROWS(

    FILTER(

        _table,

        [Count]>9

    )

)

[v-zhangti · Accepted solution]

Hi, @DagmaraG 

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.

[FreemanZ · Accepted solution]

hi @DagmaraG 

try like:

Measure =

VAR _table =

ADDCOLUMNS(

    VALUES(TableName[Product]),

    "Count",

     CALCULATE(COUNTROWS(TableName))

)

RETURN

COUNTROWS(

    FILTER(

        _table,

        [Count]>9

    )

)