Percentage of subtotal

DeanJ · January 29, 2021, 4:40pm

Hi all,
I think is something simple, but I’m trying to get the % of subtotal by product like in the image below.

Desired Results

Here is a sample .pbix
Product Sample.pbix (29.3 KB)

Thanks,
DJ

Rajesh · January 29, 2021, 5:05pm

@DeanJ

Create measure

Product Sample.pbix (33.1 KB)

DeanJ · January 29, 2021, 5:18pm

Thanks @Rajesh I will give this a try!

akila789 · January 30, 2021, 5:12am

@Rajesh,
Thanks for the solution.
small suggestion. Replacing ALL with ALLSELECTED will work well when if location and product use as the slicers.

Rajesh · January 30, 2021, 6:43am

@akila789

Thanks for your suggestion. Which one to use depends on business requirement, how they want to see final results.

If they want to see % Of Sub Total across all products in the location then they have to use All.
If they want to see % Of sub Total only on selected products then we can use All selected.

There are many ways to improve performance of the DAX, but we don’t know exact data model.

EnterpriseDNA · February 1, 2021, 1:56am

Hi @DeanJ, did the response provided by the users and experts help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark the thread as solved. Thanks!