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,
So I wanna create a measure that tells me whats the max value of another measure and looks basically like this:
My measure is the Sales Var that calculates this year sales against last years per store per week and i wanna calculate the max Sales Var per Week
is this possible to do?
thanks in advance for your time to help me!
Solved! Go to Solution.
@Anonymous
You may refer to the DAX below.
Measure = MAXX ( ALLSELECTED ( 'Table'[Store] ), [Sales Var] )
Please refer
https://community.powerbi.com/t5/Desktop/highest-value-by-category/td-p/428758
https://community.powerbi.com/t5/Desktop/Filter-only-highest-value-by-category/td-p/117841
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information.
Thanks.
Thanks for your answer but neither of this post helps me 4 now
@Anonymous
You may refer to the DAX below.
Measure = MAXX ( ALLSELECTED ( 'Table'[Store] ), [Sales Var] )
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 |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |