Forum Discussion

Chrisblanc's avatar
Chrisblanc
Regular Visitor
7 years ago
Solved

COUNTIF formula to PowerBI

Hi all !   As you can see in the screenshot below, I have different titles in one colomn that I would like to sort into 2 categories. I have written the formula in Excel but I don't know how to tra...
Need Help
  • yelsherif's avatar
    yelsherif
    7 years ago

    Basically, COUNTIF os translated into CALCULATE(COUNT(countable item/column), <condition>)

    So, depending on whether you want the calculation as an added column or as a measure, the direct translation will look like

     

    =IF(CALCULATE(COUNT(Table1[Raw Title]),Table1[Raw Title]="Mr")>0, "Men", "Women")

     

    and alternatively, you can simply write the following calculated column

    NewColumn = if(or([Raw Title]="Mr", [Raw Title]="Heer"), "Men", "Women")

    Then a new measure to count Men and Women if needed

yelsherif's avatar
yelsherif
Icon for Resolver IV rankResolver IV
7 years ago

Basically, COUNTIF os translated into CALCULATE(COUNT(countable item/column), <condition>)

So, depending on whether you want the calculation as an added column or as a measure, the direct translation will look like

 

=IF(CALCULATE(COUNT(Table1[Raw Title]),Table1[Raw Title]="Mr")>0, "Men", "Women")

 

and alternatively, you can simply write the following calculated column

NewColumn = if(or([Raw Title]="Mr", [Raw Title]="Heer"), "Men", "Women")

Then a new measure to count Men and Women if needed

Chrisblanc's avatar
Chrisblanc
Regular Visitor
7 years ago

I knew it was simple I was complicating everything for nothing. Thank you so much you just saved me from burnout