% for each category

[sportive92003]

Hello,

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

thanks!

[sportive92003]

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

[Selva-Salimi]

@sportive92003 

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]

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 · Accepted solution]

@sportive92003 

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