topic Re: Total by Product & Subgroup in DAX Commands and Tips

Total by Product & Subgroup

Aravind_Kumar — Thu, 19 May 2022 17:40:33 GMT

Hello Guys : Can you pls provide some guidance to do this % of Cost Column (4) which is the total within product and category of that product ?

amitchandak — Fri, 20 May 2022 02:26:28 GMT

Aravind_Kumar , Try a measure like

divide(Sum(Table[Cost]),calculate(Sum(Table[Cost]), allexcept(Table, Table[SKU])))

divide(Sum(Table[Cost]),calculate(Sum(Table[Cost]), filter(allselected(Table), Table[SKU] = max(Table[SKU]))))

Icey — Tue, 24 May 2022 08:59:05 GMT

You can try what amitchandak mentioned, it will give you the expected result. And here is the test result:

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.