Forum Discussion

amandabus21's avatar
amandabus21
Icon for Helper V rankHelper V
4 years ago
Solved

DAX Measure

Im trying to create a measure where:

 

(Schedule - Late Trains) / Schedule

 

I have this formula which partially works, but its not doing the (Schedule - Late Trains) first. 

 

How can I correct this so it follows PEMDAS rules?

 

OTP =
DIVIDE(
    SUM('v_MonthlyStats'[Trips Sched]) - SUM('v_MonthlyStats'[Late Trains]),
    SUM('v_MonthlyStats'[Trips Sched])
)

 

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi amandabus21 

    So you have fixed your problem , right ? If yes , please consider Accept it as the solution to help the other members find it more quickly .

     

    Best Regards,
    Community Support Team _ Ailsa Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi amandabus21 

    So you have fixed your problem , right ? If yes , please consider Accept it as the solution to help the other members find it more quickly .

     

    Best Regards,
    Community Support Team _ Ailsa Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.