Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
zsss
Frequent Visitor

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

 

zsss_2-1682162675776.png

However it is showing when I drill up

 

zsss_3-1682162694202.png

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 2
zsss
Frequent Visitor

Hi all, I faced another issue.
The matrix table takes too long to load.

zsss_0-1682409316201.png

 

 


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.

zsss
Frequent Visitor

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.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.