Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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.