Forum Discussion

Carlo1975's avatar
Carlo1975
Icon for Helper I rankHelper I
5 years ago
Solved

countif

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.

 

SellerCount Seller
000658621
000496742
000496742
000382811
000326842
000531951
000326842
000780921
000496751
000780951

 

thank you

  • AlB's avatar
    AlB
    5 years ago

    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 

     

1 Reply

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion
    5 years ago

    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