DAX Conditional count of same values

[thhmez7]

Hi guys,

in this example I want to count the products which have more than two rows, in combination with Brand.

Here Products C and E appear three times, so only these should be counted as 1 product. Other are counted as 0.

The sum would be 2.

Thank you for your help.

[v-zhangti · Accepted solution]

Hi, @thhmez7 

You can try the following methods.

Maesure:

Count =
COUNTX (
    FILTER (
        SUMMARIZE ( 'Table', 'Table'[Product], "count", COUNT ( 'Table'[Product] ) ),
        [count] > 2
    ),
    [Product]
)

Is this the result you want?

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.

[thhmez7]

Yes, it works, thank you.

Basically similar to the previous measure, just count instead of countrows.

Thank you guys

[amitchandak]

@thhmez7 , Try a measure like

countx(Filter(Summarize(Table, Table[product], "_cnt", countrows(Table)), [_cnt] >2), [product])

[thhmez7]

Hi @amitchandak 

thanks, I tried it

But it returns this error: