Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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(...))
@alisonpappas , measure like these ?
Countx(filter(Table, Table[status]="Won"), Table[ID])
calculate(Count(, Table[ID]),filter(Table, Table[status]="Won"))
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
@alisonpappas , measure like these ?
Countx(filter(Table, Table[status]="Won"), Table[ID])
calculate(Count(, Table[ID]),filter(Table, Table[status]="Won"))
@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(...))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |