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

SivaMani's avatar
SivaMani
Resident Rockstar
8 years ago

Anonymous,

 

Create a measure like below,

 

% =
var __a = CALCULATE(COUNTROWS(Table1),Table1[Status] = "A" )
var __b = CALCULATE(COUNTROWS(Table1),Table1[Status] = "B" )
Return
DIVIDE(__b,__a)

 

Then change the format as Percentage located under modeling Tab

 

Regards ,

Siva