Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 the measure in a matrix table and find these values when they are filtered by a location (column value)...
5.3%
6.3%
11.2%
12.6%
10.3%
12.8%
9.8%
5.7%
But can I use DAX to show the min and max values of the above to show as per the below?
Max
5.3% 12.8%
6.3% 12.8%
11.2% 12.8%
12.6% 12.8%
10.3% 12.8%
12.8% 12.8%
9.8% 12.8%
5.7% 12.8%
Solved! Go to Solution.
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!
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!
Try 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
23 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
42 | |
39 | |
19 | |
19 |