Running total measure loading much time

[Anonymous]

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 

Running Sales Value Items =

CALCULATE(

[Sales Value],

TOPN([Rank Article Code Sales Value],ALL(Items[Article Code]),[Sales Value])

)

[v-robertq-msft]

Hi, 

Would you like to try to change the measure formula like this to check if it can achieve your requirement:

Running Sales Value Items =

CALCULATE(

[Sales Value],

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:

https://powerbi.microsoft.com/en-us/blog/4-recommended-practices-for-new-dax-users/ 

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

[Anonymous]

Give error yellow message : 
The MAX function only accepts a column reference as the argument number 1

[v-robertq-msft]

Hi, 

Try to change the DAX formula like this:

Running Sales Value Items =

CALCULATE(

SUM([Sales Value]),

FILTER(ALL(Items[Article Code]), [Rank Article Code Sales Value]<=MAX([Rank Article Code Sales Value]))

)

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

[Anonymous]

@v-robertq-msft 
The Same massesge 

The MAX function only accepts a column reference as the argument number 1

We can not put measure after max, we should put a column 

[Anonymous]

The MAX function only accepts a column reference as the argument number 1