Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I want to create a measure that returns me the maximum value of a RANK. In this example, I wanted the value 12 (which would be the maximum value) to be returned for all rows. Any tips?
Please try this expression
Max Rank = MAXX(VALUES('Table'[Papel]), [rank div liquida/ebit])
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
It didnt work 😕
calculate(max([rank div liquida/ebit]),allselected('table'[papel]))
its impossible to use Max, because its not a column. Its a measure 😕
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 11 | |
| 9 | |
| 9 | |
| 6 | |
| 5 |
| User | Count |
|---|---|
| 27 | |
| 22 | |
| 19 | |
| 17 | |
| 11 |