So... for something different.
I created the following in a custom column:
Go to Solution.
Juse use a MAXX or MINX on that single row table, if I understand what you are saying.
Proud to be a Datanaut!
When I tried it, it didn't work and BI suggested it was due to string value. Now this Super User comes along and suggests my earlier thought and it just does somehow work.... how....? (rhetorical)
@Greg_Deckler Thanks Greg.
I was wondering because it seemed like you had done that for VAR2. Perhaps you used a numerica aggregation before like SUMX?
I think it is most likely that I made an error in my context which made it happen that one of the applied filters wasn't working, thus you would have multiple results. Something that might break it, I assume.
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.