How write powerbi formula Countifs

[Augustas-ase]

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

[v-yalanwu-msft]

Hi, @Augustas-ase ;

Is your problem solved? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

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 · Accepted solution]

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.

[Augustas-ase]

Maybe need to use two filters in the formula? Firstly to COUNTIFS(L:L;[@VALUE] after N:N;"YES"..

[PC2790]

Yes, because there are two criterias in the CountIFs

Something like Filter(TableName,Condition1 && Condition 2) and then you can enclose it in IF

[Augustas-ase]

also maybe there is a difference that is L: L numbers and N: N Text maybe that's why it doesn't work out for me exactly, i get inaccurate information

[PC2790]

Can you provide me the data set, I don't understand what L and N are.

A similar requirement can be found here

[Augustas-ase]

[Augustas-ase]

can you write the whole condition what it should look like?

[Augustas-ase]

in excel is: =IF(COUNTIFS(L:L;L1;N:N;"YES")>0;"YES";"NE")

[Augustas-ase]

no doesn't work:/

[PC2790]

Are you getting any error?

Can you share your sample data?

[PC2790]

Try:

If(CALCULATE(COUNTROWS(TableName),FILTER(TableName,TableName[Value]="Yes"))>0,"Yes","No")