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!
mhossain
Solution Sage
Solution Sage
Create a measure for MAX column
= Calculate(Max(Table[your value column]), removefilter(Table[your value column]))
Try above, if in your table you have multiple fileds then you probably would need to adjust the removefilter part in the dax.
Let me know if above is making sense