Calculate % of total in matrix

[Anonymous]

Hello.

I have a PBI report that looks like the image below. The bottom matrix shows the number of payments made in the period selected by the slicer.

I want to do is calculate the % of payment we recieved against the total sold in that month. So as you can see in the middle visual, between 1/10/2018 and 31/102018 we sold 2868882.97. So I would want the first row in the matrix to show as 3.2% as 91.840.41 is 3.2% of 2868882.97 if that makes sense?

I have created a measure which is paid/sold and you can see this is giving 93.12% which isn't correct.. as I want it as a percentage of the total sold in the selected period.

In my matrix I have the payment date on the left and the sold date across the top. Does anyone have any ideas on how to achieve this?

[Anonymous · Accepted solution]

I have used this method to solve my issue 🙂
https://community.powerbi.com/t5/Desktop/Grouped-percentage-of-row-total/td-p/32154/page/2

[Anonymous]

of course, sorry. These are the 2 tables. Relationship is both ways on the contractID. 

[littlemojopuppy]

@Anonymous can you provide some sample data to work with?