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
You will need a few Dax measures to do it
First of all:
totalRows = CALCULATE(COUNTROWS(yourtable; yourcolumnname = "Applied"; yourcolumnname = "N/A")
Then count for "Applied" or count "N/A"
totalApplied = CALCULATE(COUNTROWS(yourtable);yourcolumnname = "Applied")
totalNA = CALCULATE(COUNTROWS(yourtable);yourcolumnname = "N/A")
Percentage
%Applied = (totalApplied / totalRows) * 100 %NA = (totalNA / totalRows) * 100
Hope this helps you out?
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