Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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] )
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
62 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |