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!
Go to Solution.
You may refer to the DAX below.
MAXX ( ALLSELECTED ( 'Table'[Store] ), [Sales Var] )
View solution in original post
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
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!