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
Anonymous
You should make the IF statement a column, then it works.... should work
Can you offer me a little more context on how to do this?
1. I have a source column with a value of True, Flase or null
2. I created a separate column and an "IF" statement to translate "True" to "Applied", else "N/A"
3. From this column, I want to count the "Applied" and the "N/A" rows
In the DAX statements I am attempting to write, PBI doesn't seem to "recognize" and autopopulate the column in the DAX statement (step 2, above)
Thanks for sticking with this!!!!