Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

% of Total by Rows DAX

Hello Power BI experts,

 

Could you guide me to tweak my DAX to calculate row by percent total? 

 

%RT Abilities is calculated by the built-in function of show by row total.

 

The Able % is calculated 

Able % = COUNT(Able[Rating])/CALCULATE(COUNT (Able[Rating]), ALL(Able))
 
But the number do not add up 100% at the row level only on the column level.
 
 

So close yet so far.

 

 

Need Help
  • parry2k's avatar
    parry2k
    3 years ago

    Anonymous change ALL to 

    ALL ( Able[Ability] )

     

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

     

     

5 Replies

  • parry2k's avatar
    parry2k
    Super User
    3 years ago

    Anonymous change ALL to 

    ALL ( Able[Ability] )

     

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi parry2k,

       

      Thank you for the advice.  The tweak did not produce the intended outcome. I would like to replicate the row percent calculated using the built-in function with a DAX. 

       

      I have a screenshot of the updated measure and the table to show that the percent is row using the built-in function. Let me know if you have any more suggestions or questions.

       

       

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thank you parry2k.

       

      The tweak to the DAX worked. I can build graphs with DAX that match the built-in function.

       See below.

       

       

       

       

      Thank you.

       

       

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    Hi,

    Your question is not clear.  Share the download link of your PBI file and show the expected result.

  • parry2k's avatar
    parry2k
    Super User
    3 years ago

    Anonymous awesome, good to hear. 

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.