Solved: COUNT IF on DAX: Excel formula works so fine, but ...

LeandroCampacci · ‎08-20-2021

Hi everyone.

I have a spreadsheet that counts how many times a name appears in a listing and also counts how many times a conditional is listed. For example:

In this case, the expected result is:

A	3 times
B	1 time

In Excel it's perfect. But I couldn't replicate that in Power BI (I think it was the recent vacation effect).

v-shex-msft · ‎08-23-2021

You can use create a table visual with the category field and write a measure formula for counting calculations.

Measure =
CALCULATE (
    COUNTA ( Table[Category] ),
    FILTER ( ALLSELECTED ( Table ), [Status] = "Yes" ),
    VALUES ( Table[Category] )
)

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

v-shex-msft · ‎08-23-2021

You can use create a table visual with the category field and write a measure formula for counting calculations.

Measure =
CALCULATE (
    COUNTA ( Table[Category] ),
    FILTER ( ALLSELECTED ( Table ), [Status] = "Yes" ),
    VALUES ( Table[Category] )
)

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

danielwelch · ‎08-20-2021

Hi, try
calculate(count([Lettercolumn]),[listing column]="Yes")

COUNT IF on DAX: Excel formula works so fine, but in PBI...