Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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...
Need Help
Show and Tell
Tips and Tricks
  • jthomson's avatar
    jthomson
    8 years ago

    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

miltenburger's avatar
miltenburger
Helper V
8 years ago

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?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

miltenburger

 

I think the use of ";" is throwing a wrench into the application of the DAX statements.

 

Any thoughts?