Forum Discussion
Solved
How can you Normalise Measure Values (filtered by Column Value)?
Hello Power BI Community! 😊 Is there a way to normalise Measure values (filtered by a column value)? For example, to do this I think I need min and max values of my measure. Below you can see t...
Thank you! I was able to use one of the formulas from this article.
MAXX(ALLSELECTED(column filter), [Measure]) and the same for min. Works perfectly!
amitchandak
Super User
Super UserTry measures like
Max
calculate(max(Table[Value]) , all(Table))
calculate(max(Table[Value]) , allselected(Table))
Min
calculate(Min(Table[Value]) , all(Table))
calculate(Min(Table[Value]) , allselected(Table))
refer
https://www.linkedin.com/pulse/five-recent-power-bi-functions-you-should-use-more-often-amit-chandak