Forum Discussion
Count Statuses - DAX Help!!!!
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
Do you use it as a measure, or do you create a new column (because you should make a new column)
Then you can put CC instead of yourcolumnname which i used in my measures
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
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!!!!