Forum Discussion

DIACHROMA's avatar
DIACHROMA
Icon for Helper II rankHelper II
5 years ago
Solved

Capped target in DAX

Hello Dax Lovers,  I need some help ðŸ˜Š   I would like to calculate a rate of progress in relation to an objective, but this rate must be capped at 100%.   Example of what I currently have: N...
DAX
  • daxer-almighty's avatar
    daxer-almighty
    5 years ago

     

    // If such measures do not work blazingly fast,
// then you have a problem in your model. 100%.

[Capped Achievement] = MIN( 1, DIVIDE( [Achieved], [Goal] ) )

[Surplus] = MAX( 0, [Achieved] - [Goal] )

     

daxer-almighty's avatar
daxer-almighty
Icon for Solution Sage rankSolution Sage
5 years ago

 

// If such measures do not work blazingly fast,
// then you have a problem in your model. 100%.

[Capped Achievement] = MIN( 1, DIVIDE( [Achieved], [Goal] ) )

[Surplus] = MAX( 0, [Achieved] - [Goal] )

 

  • DIACHROMA's avatar
    DIACHROMA
    Icon for Helper II rankHelper II
    5 years ago

    Hi daxer-almighty , it works perfectly and it's super fast!

     

    THAAAANKS !!!!

    Pauline

  • tausif124's avatar
    tausif124
    New Member
    3 years ago

    daxer-almighty can you explain to me what the cap achievement measure is doing? I just tried it for my need and its working.