topic Re: Matrix Row % of the Total in DAX Commands and Tips

Matrix Row % of the Total

je7golf — Thu, 20 Jun 2024 02:18:03 GMT

Hello,

I am new to Power BI I am trying to do what I thought would be simple and am struggling. I would like to add an additonal column and calculate the % of On Time for the row.

For Example:

Employee % On Time = 70%

National % On Time = 76.4%

Thank you,

Re: Matrix Row % of the Total

rajendraongole1 — Thu, 20 Jun 2024 04:10:07 GMT

Hi je7golf - Create a below measure to find the % percentage

Measure:

% On Time1 = DIVIDE(SUM(Matrix[On Time]), SUM(Matrix[On Time]) + SUM(Matrix[Late]), 0)

above % measure, place it at values

Total = SUMX(Matrix,Matrix[On Time] + Matrix[Late])

it works please check.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Re: Matrix Row % of the Total

je7golf — Thu, 20 Jun 2024 22:40:32 GMT

Hello, this is the error I keep getting.

Re: Matrix Row % of the Total

Anonymous — Fri, 21 Jun 2024 02:15:59 GMT

Hi je7golf ,

Thank you rajendraongole1 very much for the solution,

Regarding the problem you encountered later, I think it might be your use of brackets that is causing, some problems, and you can modify it according to the scenario I gave you.

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.