Count Double Entries in a Table

Daniel1908 — Wed, 07 Jul 2021 13:32:21 GMT

Hello Together,

I am using the below expression.

=Count(distinct{$-1<Material>} If([Price]>1,1,0))

I want to count the material where the equal price appears more than once in the list.

Thanks for your help.

Kind Regards,
Daniel

Re: Count Double Entries in a Table

Kushal_Chawda — Wed, 07 Jul 2021 13:59:31 GMT

@Daniel1908 try below. If doesn't worl share sample data with expected output.

= count(if(aggr(count(Price),Material,Price) > 1 , Material))