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!
Please read about ALLSELECTED. This is the function to use but it's tricky.
https://www.sqlbi.com/articles/the-definitive-guide-to-allselected/
https://www.sqlbi.com/articles/the-definitive-guide-to-allselected/
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!