I created a measure of running sales quantiy to make a pareto 20/80 (I prefer measure not table to be sliced by date and retail)but it takes much time to load in every table or visual it contributes
Would you like to try to change the measure formula like this to check if it can achieve your requirement:
Running Sales Value Items =
FILTER(ALL(Items[Article Code]), [Rank Article Code Sales Value]<=MAX([Rank Article Code Sales Value]))
If you still have a problem, please refer to this link for the DAX best practice to improve your DAX formula:
Thank you very much!
Community Support Team _Robert Qin
Give error yellow message : The MAX function only accepts a column reference as the argument number 1
Try to change the DAX formula like this:
@v-robertq-msft The Same massesge
The MAX function only accepts a column reference as the argument number 1
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.