Forum Discussion
Solved
Set a maximum value for a decimal column
I have a decimal column in my table which can have values in the range 0-200. But When ploting in a line graph I want the maximun value to be 100. For example let's say there is a value in that colum...
Hi Deepan
You could try a calculated measure like this.
Measure = VAR coreMeasure = CALCULATE(SUM('Table2'[Values])) RETURN IF( coreMeasure>100, -- THEN -- 100, -- ELSE -- coreMeasure )You can apply the same approach on a Calculated Column if you prefer
Just replace the code for the core measure with your own code.
Hi Deepan
You could try a calculated measure like this.
Measure =
VAR coreMeasure = CALCULATE(SUM('Table2'[Values]))
RETURN
IF(
coreMeasure>100,
-- THEN --
100,
-- ELSE --
coreMeasure
)You can apply the same approach on a Calculated Column if you prefer
Just replace the code for the core measure with your own code.