The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 😕