% of Total by Rows DAX

[Anonymous]

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.

[parry2k]

@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.

[Ashish_Mathur]

Hi,

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

[parry2k · Accepted solution]

@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]

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.

[Anonymous]

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.