Forum Discussion
Issue Grouping with Percentage
Hi just started with powerbi, I’m having issue with grouping sales amount percentage based on cumulative percentage.
I would like my table to be like this
However it is showing when I drill up
I suspect due to filtering, it filter all the amount to Top 50% and 0 amount to Next 30% and Others.
I tried looking around but could not find anything useful
if can, I would also like the product to be in both group if the previous cumulative is not above the condition and by adding the current cumulative, it went above the threshold. Eg from the image,
Aliqui YY-15 should be in Top 50% and Next 30%
Please guide me through thankyou for your time.
data.pbix
2 Replies
Hi all I’ve solved the filtering part, would like to know if there is anyway to put a product sorted in to both group like the example I said above.
Hi all, I faced another issue.
The matrix table takes too long to load.
The Matrix Values is the same measure code as group product sales amount with different CALCULATE([PARAMETER])
are my dax not optimize or should I not use matrix.
https://drive.google.com/u/0/uc?id=1ou6R82zjTcFTaWUSgPyNyQCv2kZpuzkh&export=download
In my working file, Performance analyzer showing that it takes 90000ms to load the page.
