Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |