Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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
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.
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.