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.Can any one help me to get the dax function.

 

Thanks in advance.

 

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.

3 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    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.