Forum Discussion

davorgom's avatar
davorgom
Frequent Visitor
6 years ago
Solved

Help

  Hello everyone. I have been trying to subtract values ​​from a table with a fixed measurement (first in the ranking, second, third ...), but I can't. I would like to know if any of you can help ...
Substract with a measure
  • nandukrishnavs's avatar
    nandukrishnavs
    6 years ago

    davorgom  if you want to compare with 6th position,  This should be calculated column, not measure

     

     

    Compare 6th Position = 
var _sub=FILTER('Table','Table'[Position]=6)
var _2max=MAXX(_sub,[Distance])
var result= _2max-'Table'[Distance]
return result

     

    This should be calculated column, not measure.

     

    Can you provide your original data, so that i can test it.

    Also I have modified my reply a little bit. Please try again.



    Did I answer your question? Mark my post as a solution!
    Appreciate with a kudos     🙂

nandukrishnavs's avatar
nandukrishnavs
Community Champion
6 years ago

davorgom 

 

 

PositionDistance
110.5
210.3
39
47
56
65

 

Create two calculated columns.

 

 

 

Compare 1st Position = 
var _1max=MAX('Table'[Distance])
var result= _1max-'Table'[Distance]
return result
Compare 2nd Position = 
var _sub=FILTER('Table','Table'[Position] = 2)
var _2max=MAXX(_sub,[Distance])
var result= _2max-'Table'[Distance]
return result

 

 

 



Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

 

  • davorgom's avatar
    davorgom
    Frequent Visitor
    6 years ago

    I appreciate your answer. I wanted to tell you that when I copied and pasted the DAX formula, I get an error in the penultimate line. Do you know why it could be?

     

    On the other hand, I saw the two measurements, and they only differ from each other using MAX and MAXX. If I wanted to compare the value of the 6th position with the rest of the results, what should I change?

     

    I appreciate your time and knowledge.

     

    Blessings from Colombia

    • nandukrishnavs's avatar
      nandukrishnavs
      Community Champion
      6 years ago

      davorgom  if you want to compare with 6th position,  This should be calculated column, not measure

       

       

      Compare 6th Position = 
var _sub=FILTER('Table','Table'[Position]=6)
var _2max=MAXX(_sub,[Distance])
var result= _2max-'Table'[Distance]
return result

       

      This should be calculated column, not measure.

       

      Can you provide your original data, so that i can test it.

      Also I have modified my reply a little bit. Please try again.



      Did I answer your question? Mark my post as a solution!
      Appreciate with a kudos       🙂