cancel
Showing results for 
Search instead for 
Did you mean: 

Running total measure loading much time

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])
)
Status: New
Comments
v-robertq-msft
Community Support

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

islamabdelghany
Frequent Visitor

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

v-robertq-msft
Community Support

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

islamabdelghany
Frequent Visitor

@v-robertq-msft 
The Same massesge 

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