Forum Discussion

Augustas-ase's avatar
Augustas-ase
Helper II
4 years ago
Solved

How write powerbi formula Countifs

Hello, How to write Formula from excel to Powerbi My formula in excel is =IF(COUNTIFS(L:L;[@VALUE];N:N;"YES")>0;"YES";"NE") please help me
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Augustas-ase ;

    Sorry, is countif not being used correctly on the way as I understand it, or can you share what your results are?
    A simple example and want to output the result, attached to your logic. If we switch to Powerbi from Countif,
    You can use:

    count =
IF (
    CALCULATE ( COUNT ( [column] ), FILTER ( ALL ( table ), [column1] = "Yes" ) ) > 0,
    "Yes",
    "No"
)


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, Augustas-ase ;

Sorry, is countif not being used correctly on the way as I understand it, or can you share what your results are?
A simple example and want to output the result, attached to your logic. If we switch to Powerbi from Countif,
You can use:

count =
IF (
    CALCULATE ( COUNT ( [column] ), FILTER ( ALL ( table ), [column1] = "Yes" ) ) > 0,
    "Yes",
    "No"
)


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.