Row % total

[carly_030]

I have matrix table as below where the % is worked out from measure/days available. 

How can I get the total (in bold) to be the % of that total i.e. 67/441 - 15% and not 319%?

Thanks in advance 🙂

[carly_030]

@v-jianpeng-msft thank you.  This worked perfectly

[Anonymous · Accepted solution]

hi, @carly_030 

I'm happy to answer your questions. Here I offer my solution，We can use the following dax formula:

Column = CALCULATE(DIVIDE(SUM(Tabelle1[meausre]),SUM('Tabelle1'[day])))

Then change the format of the calculated column to percentage:

The results are as follows:

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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