Forum Discussion
Count Statuses - DAX Help!!!!
I am currently using an "IF" function to apply a value of "Applied" or "N/A" within a column of a table. I am looking for some help in a DAX statement that will allow me to do the following: Co...
Something like:
Total Applied = calculate(countrows(your table),your table[your column]="Applied")
Do similar for N/A and the percentage of these should be trivial from there
The "IF" Statement is a function.
When I follow your suggestion and type the DAX statement, eeverything seems in order until I try to name the column. It does not autopopulate and the DAX statement fails.
Anonymous
You should make the IF statement a column, then it works.... should work