topic Re: % for each category in DAX Commands and Tips

% for each category

sportive92003 — Mon, 09 Sep 2024 14:30:52 GMT

Hello,

I would like to distribute the % for each category of product. I did a selection for only the clients we are lost.

thanks!

Selva-Salimi — Mon, 09 Sep 2024 15:49:52 GMT

you should write a measure as follows:

measure percentage :=

var total = calculate (sum(diff) , all(table)) -- or you can use allselected based on what you expect

return

divide (diff, total)

If this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.

sportive92003 — Mon, 09 Sep 2024 16:04:55 GMT

Hello,

DIFF is a Measure to calculate the nomber of clients this year VS last year:

([Clients uniques Lub-Carb (présent dans un ou l'autre)]-[Clients uniques (Lub-Carb) same period]).

So in your formula it doesn't work. How to fix it?

Selva-Salimi — Mon, 09 Sep 2024 16:09:59 GMT

if you omit "sum" then it will be work.

sportive92003 — Mon, 09 Sep 2024 16:13:58 GMT

That works! Thank you very so much ! So happy to get your help!