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.
Hi,
I would like to calculate the Cumulative Qty% like it shows in the excel spreadsheet below. I created a measure for the calculation. But the calculation doesn't seem to be accurate. Can someone point me what is wrong with my measure?
Solved! Go to Solution.
Hi,
You may refer to my solution in this PBIX file.
Hope this helps.
Hi @jessiew,
I'm not clear about your sample data so I made a test with a sample data similar with yours, but I add an Index column to calculate the cumulative percentage.
Measure = CALCULATE ( SUM ( 'Table1'[Column] ), FILTER ( ALL ( 'Table1' ), 'Table1'[Index] <= MIN ( 'Table1'[Index] ) ) )
You could have a reference of the formula above.
Hope this can help you!
Best Regards,
Cherry
Hi,
The excel spreadsheet Sheet 4 indicates the calculation of the cumulative qty%. See below link for the share:
https://drive.google.com/open?id=1EYU9r_EUvXIXpmrMcwqRkh5iivuDgRyT
The pbix file is at below link:
https://drive.google.com/open?id=1T3wi2ENCwqAelFUmxbsftFEtFGRE8a2M
Hi,
Reduce the file size to a few kb's only. Also, whenever you share a download link, always mention the file size if it it more than 1 MB. How will i otherwise know the size of the file that i am downloading.
I'm new to this forum. I don't see other peopel who shared the link mentioned the size of the file so I didn't do that.
I tried my best to reduce the file size, but it cannot be only a few KBs. Otherwise the excel sheet and pbix file result will not match.
Here's the new link for the pbix file and excel spreadsheet.
The pbix file is 1.5MB, the excel spreadsheet is 3.5MB (the excel sheet is zipped).
The new link for the pbix file is https://drive.google.com/open?id=1ut6hEXd6jqbRUaDA1NUzMXhOsNXLa9iQ
The new link for the excel spreadsheet is https://drive.google.com/open?id=1ztDDcsthWK-cvAZTuIgOOUvtF_lDt26M (sheet 4 has the Cumulative Qty% calculation).
Thanks!
Hi,
You may refer to my solution in this PBIX file.
Hope this helps.
Thanks so much Ashish. It worked.
You are welcome.
Hi,
Please share the download link of the Excel file that you have pasted in the screenshot.
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 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |