Forum Discussion
sportive92003
Helper II
Helper II% for each category
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
Solution Sage
Solution Sage
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.
sportive92003Hello,
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