Forum Discussion
Solved
ABS calculation
Hi team, I’m trying to create a measure, but I’ve some issues with syntax. Could you be able to help? I need the following measure: Measure % = (1 – ABS((cost1 – cost2)/cost1)*100 and if cost2>= 2...
Hi nasbkrv
you can do it like this:
Measure % = VAR _Cost1 = MIN('Table'[Cost1 ]) VAR _Cost2 = MIN('Table'[Cost2 ]) RETURN IF(_Cost2 >= 2 * _Cost1 || _Cost1 = 0 , 0 , 1 - ABS((_Cost2 - _Cost1) / _Cost1) )With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
Hi nasbkrv
you can do it like this:
Measure % =
VAR _Cost1 = MIN('Table'[Cost1 ])
VAR _Cost2 = MIN('Table'[Cost2 ])
RETURN
IF(_Cost2 >= 2 * _Cost1 || _Cost1 = 0 ,
0 ,
1 - ABS((_Cost2 - _Cost1) / _Cost1)
) With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)