cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
davorgom
Frequent Visitor

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 me.

 

 

Screenshot_20200508-235009_Excel.jpg

 

1 ACCEPTED SOLUTION

@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
🙂

View solution in original post

3 REPLIES 3
nandukrishnavs
Community Champion
Community Champion

@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

 

 

 

Capture.JPG



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

 

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. Anotación 2020-05-09 123200.jpgDo 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

@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
🙂

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors