Forum Discussion
Calculate the cummulative sum in Matrix with sorting applied and then 50% of it on the Measure
Hi All,
I have a matrix wherein i am trying to calculate the running total partition by three dimension in sequence Document No., Product Name and Product ID.
Data source:
calculating measure Distinct_count_of_Srno.
The running total (cummulative sum) should be calculated based on the descending order of the measure. Please find below scenario
Matrix i want to achieve finally:
Take the example of Document no= XXX,Product Name = ABC and Product ID = 120.
Here we have final running total 12 for the group Document No, Product Name and Product ID.
Taking half of running total which is 12/2 = 6.
now finally calculating how many disticnt feature required to get 50% of running total which in our case is 2 feature.
I have uploaded the sample excel and the pbix
password-12345
Please let me know in case of any questions.
Thanking you in anticipation!
Regards,
Robin Yadav
4 Replies
- Jihwan_Kim
Super User
Hi Jihwan,
I tried approach suggested by you.
It is giving proper output but it is working only for specified column which I shared with you in excel.
To make it other slicer effective on it , instead of "ALL" in DAX I changed to "ALLSELECTED".
It is not working for large size of data.
Giving below error:
can you please suggest for larger volume of data.
Regards,
Robin Yadav
- Jihwan_Kim
Thank you for your feedback.
Please share your sample pbix file's link here, then I can try to look into it to come up with accurate solution.
Thanks.
