cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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.

1 ACCEPTED SOLUTION
Community Champion

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

Appreciate with a kudos
🙂

Regards,
Nandu Krishna

3 REPLIES 3
Community Champion

 Position Distance 1 10.5 2 10.3 3 9 4 7 5 6 6 5

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``````

Appreciate with a kudos
🙂

Regards,
Nandu Krishna

Frequent Visitor

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

Community Champion

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

Appreciate with a kudos
🙂

Regards,
Nandu Krishna

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors