Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 |
Solved! Go to Solution.
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
@tamerj1
The solution worked well. It sent me in the right direction for finding my own solution using your example as a base.
Thanks!
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
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
User | Count |
---|---|
21 | |
19 | |
12 | |
9 | |
8 |
User | Count |
---|---|
30 | |
27 | |
14 | |
13 | |
10 |