cancel
Showing results for
Did you mean:  Helper V

## Min and Max from Column 1 based on range defined by Column2

Hello,

The max values from Column2 define the range of values I need from Column1.
For example, 5 is the max value from Column2.
The max value from Column1 = 6
The min value from Column1 = 2

How do I retreive the values 6 and 2 from Column1 based on range defined by the Max values in Column2?

Ultimately I want the difference: 6-2 = 4

Thank you...

 Column1 Column2 9 1 8 2 7 3 6 5 5 5 4 5 3 5 2 5 1 2
1 ACCEPTED SOLUTION  Super User

I assume you will be using a card visual you may try.

``````Measure1 =
VAR Column2Max =
MAX ( 'Table'[Column2] )
VAR MaxVakueTable =
FILTER ( 'Table', 'Table'[Column2] = Column2Max )
VAR Column1Max =
MAXX ( MaxVakueTable, 'Table'[Column1] )
VAR Column1Min =
MINX ( MaxVakueTable, 'Table'[Column1] )
RETURN
Column1Max - Column1Min``````
3 REPLIES 3  Helper V

@tamerj1
The solution worked well.  It sent me in the right direction for finding my own solution using your example as a base.
Thanks!  Community Support

Hi @roncruiser ,

Has your problem solved by @tamerj1 's solution? If yes, please consider accept it as the solution to help the other members find it more quickly.

Best Regards,
Community Support Team _ kalyj  Super User

I assume you will be using a card visual you may try.

``````Measure1 =
VAR Column2Max =
MAX ( 'Table'[Column2] )
VAR MaxVakueTable =
FILTER ( 'Table', 'Table'[Column2] = Column2Max )
VAR Column1Max =
MAXX ( MaxVakueTable, 'Table'[Column1] )
VAR Column1Min =
MINX ( MaxVakueTable, 'Table'[Column1] )
RETURN
Column1Max - Column1Min``````   