Forum Discussion

suryakamesh's avatar
suryakamesh
Regular Visitor
8 years ago
Solved

DAX Function for COUNTIF and/or CALCULATE

Hi need help on DAX,   I have a data of columns names as ,student name and status(pass/fail).so need to calculate the pass% and fail% for total ppulation of students with the use of dax funftion....
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Try this measures

     

    Pass % =CALCULATE(COUNTROWS(Data),Data[Status]="Pass")/COUNTROWS(Data)

    Fail % =CALCULATE(COUNTROWS(Data),Data[Status]="Fail")/COUNTROWS(Data)

     

    Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

This worked great!  Thank you.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

You are welcome.