countif

[Carlo1975]

I'm Sorry, but I wrote this in the power query forums but I think that is better with dax. I have a table with a lot of columns.

I wanto to add a column in wich I will count how many time the value of Sell columns is repeated like if I use CountIf in excel. For me is the same from DAX or Power Query.

Seller	Count Seller
00065862	1
00049674	2
00049674	2
00038281	1
00032684	2
00053195	1
00032684	2
00078092	1
00049675	1
00078095	1

thank you

[AlB · Accepted solution]

Hi @Carlo1975 

Count Seller =
CALCULATE ( COUNT ( Table1[Seller] ), ALLEXCEPT ( Table1, Table1[Seller] ) )

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers