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
I think the use of ";" is throwing a wrench into the application of the DAX statements.
Any thoughts?
Hi Anonymous
Jep, my system needs a " ; "
Your system possibly needs a " , "
This is the statement that I am using to translate a "True/False"
CC = if('KPI Dashboard AD'[(Campaign) CC]=TRUE(), "Applied", "N/A")
Your expressions don't seem compatible with my "IF" statement.
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.