topic Re: Help in DAX Commands and Tips

Help

davorgom — Sat, 09 May 2020 04:53:10 GMT

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.

Re: Help

nandukrishnavs — Sat, 09 May 2020 18:04:22 GMT

davorgom

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

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

Re: Help

davorgom — Sat, 09 May 2020 17:43:18 GMT

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

Re: Help

nandukrishnavs — Sat, 09 May 2020 18:07:43 GMT

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 🙂