% of paid Excel power pivot 2010 measure

[Page0727]

Trying to create a measure in power pivot for percentage of paid amount total a row makes, so far I am doing the following but it does not work.

= sum(table1[sum of paid]]) / calculated (sum(table1[sum of paid]), ALL(table1[UserID]))

As you can see I am not good at this, but am I anywhere near the correct calculation here? Also can anybody point me in the right direction in regards to learning a little more about learning this. Everything I search for seems to end up referring to Power BI application, not what I need at all.

Thank you

 

[Matt Allington]

I wrote an article about how all works here https://exceleratorbi.com.au/the-all-function-in-dax/

i also wrote a book book that will help anyone with a solid Excel background learn this stuff https://exceleratorbi.com.au/supercharge-excel/

the formula depends on what is in the pivot table. You may also need a star schema to make the DAX easier.