Forum Discussion

nasbkrv's avatar
nasbkrv
Regular Visitor
5 years ago
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*cost1 or if cost1= 0, the result should be 0.

The data should like:

 

Cost1 

4 

4 

4 

4 

4 

4 

4 

Cost2 

2 

3 

4 

5 

6 

7 

8 

Measure % 

50 

75 

100 

75 

50 

25 

0 

 

Thank you.

Need Help
Show and Tell
  • FrankAT's avatar
    FrankAT
    5 years ago

    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)

1 Reply

  • FrankAT's avatar
    FrankAT
    Community Champion
    5 years ago

    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)