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 ...
  • 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 

     

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