Forum Discussion
roncruiser
Post Patron
Post PatronMin 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 ...
Hi roncruiser
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
roncruiserPost Patron
Post Patrontamerj1
The solution worked well. It sent me in the right direction for finding my own solution using your example as a base.
Thanks!