DAX Count If Help

[alisonpappas]

Hi All,

I am trying to figure out a DAX equation to use. I believe a "count if" equivilant may be what I am looking for.

I have a bunch of data with different columns, and one coulmn describes the data as "won, lost, no response, waiting." I want to take the count of items that are "won." How do I do this?

Thanks,

Alison

[Greg_Deckler · Accepted solution]

@alisonpappas Refer to this: https://community.powerbi.com/t5/Community-Blog/Excel-to-DAX-Translation/ba-p/1060991

https://community.powerbi.com/t5/Community-Blog/CO-CU-Excel-to-DAX-Translation/ba-p/1080018#M2077

COUNTX(FILTER(...)...) or CALCULATE(COUNT(),FILTER(...))

[Icey]

Hi @alisonpappas ,

Please let us know if the replies above are helpful.

If they are, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If not, please give us more details.

Best Regards,

Icey

[amitchandak · Accepted solution]

@alisonpappas , measure like these ?

Countx(filter(Table, Table[status]="Won"), Table[ID])

calculate(Count(, Table[ID]),filter(Table, Table[status]="Won"))

[Greg_Deckler · Accepted solution]

@alisonpappas Refer to this: https://community.powerbi.com/t5/Community-Blog/Excel-to-DAX-Translation/ba-p/1060991

https://community.powerbi.com/t5/Community-Blog/CO-CU-Excel-to-DAX-Translation/ba-p/1080018#M2077

COUNTX(FILTER(...)...) or CALCULATE(COUNT(),FILTER(...))