Forum Discussion

pro_x's avatar
pro_x
Icon for Helper I rankHelper I
6 years ago

Dax measure

Hi 

 

I have one column, only one column that has rejected and successful. Rejected is represented by 0 and successful is represented by 1. How can I calculate the percentage difference for rejected and successful separately?

13 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    pro_x , two measures likes

    Mark all them as % column

    successful =divide(calculate(countrows(Table),Table[col]=1),countrows(Table))


    Rejected  =divide(calculate(countrows(Table),Table[col]=0),countrows(Table))

     

    percentage difference = [successful] -[Rejected]

    • pro_x's avatar
      pro_x
      Icon for Helper I rankHelper I
      6 years ago

      Hi

      Thank you,

      How would i calculate the percentage change for Rejected?

      • mhossain's avatar
        mhossain
        Icon for Solution Sage rankSolution Sage
        6 years ago

        Hi pro_x 

         

        Your problem seems interesting, what do you mean % changes for successful and rejected seprately, changes on what basis?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    pro_x Can you share some sample data and expected out? That way people here can help you quickly.

     

    Thanks

     

    • pro_x's avatar
      pro_x
      Icon for Helper I rankHelper I
      6 years ago

      This is the data I have, rejected is represented by 0 and successful is represented by 1.