Forum Discussion

robbielambert's avatar
robbielambert
Frequent Visitor
6 years ago
Solved

Calculation ordering question

Hi, thanks in advance for the help on this.   I have two measures which are quite complex. that yield results at a row level that look something like this:   Account Id Measure A Measure B ...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi robbielambert ,

     

     

    Suppose your measures are Measure AA and Measure BB

     

    Diff of Measure = SUMX('Table',[Measure AA] - [Measure BB])

     

    Final Measure = 

SUMX('Table', IF ([Diff of Measure] < 0 ,0, [Diff of Measure]))

     


    Regards,

    Harsh Nathani


    Appreciate with a Kudos!! (Click the Thumbs Up Button)

    Did I answer your question? Mark my post as a solution!

     

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi robbielambert ,

 

 

Suppose your measures are Measure AA and Measure BB

 

Diff of Measure = SUMX('Table',[Measure AA] - [Measure BB])

 

Final Measure = 

SUMX('Table', IF ([Diff of Measure] < 0 ,0, [Diff of Measure]))

 


Regards,

Harsh Nathani


Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

 

 

 

robbielambert's avatar
robbielambert
Frequent Visitor
6 years ago

Hi Harsh,

 

Works like a treat!

 

You are a scholar and a gent thank you!

 

Robbie