Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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
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
of course, sorry. These are the 2 tables. Relationship is both ways on the contractID.
@Anonymous can you provide some sample data to work with?
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
68 |