Forum Discussion
Syndicate_Admin
Administrator
AdministratorSave a total to a variable
Nice day I have this problem, you want to save the total of the column "Vta x M2" (1.433) in a single fixed variable to use it for a color conditional. Vta x M2 is the result of dividing "Sal...
lbendlin
Super User
Super UserAre you planning to use a measure or a calculated column? Is the color impacted by users interacting with the report or is it fixed ?
Syndicate_AdminIt is a measure.
The color will give according to the conditional.
I did tests and I think that with calculate, it would work for me:
CALCULATE ([Vta x M2],(ALLSELECTED(Stores)))