Measure is extremely slow (Takes up to 30 seconds to load the visual)

[Giorgi1989]

Dear All,

Your help with or advice on the subject would be highly appreciated:

I have this measure that is extremely slow:

It takes up to 30 seconds to load the visual (Line and stacked column chart)

• Pareto Chart Materials =

  VAR MatGP = [Total Gross Profit]

  VAR AllProfit = CALCULATE([Total Gross Profit], ALLSELECTED('Customer Profitability (Margins)') )

  
  

  return

  DIVIDE(

  SUMX(

  FILTER(

  SUMMARIZE( ALLSELECTED('Customer Profitability (Margins)'), 'Customer Profitability (Margins)'[Material],

  "GP" , [Total Gross Profit] ) ,

  [GP] >= MatGP ) ,

  [GP] ) ,

  AllProfit , 0 )

 Any suggestion as to how to tweak this to make faster?

Thank you in advance.

[milanpasschier2]

Hi, you could create a TOP N filter on the visual itself.

[Giorgi1989]

Hi, thank you for the reply. I could in theory, but I don't think that would be something optimal for my situation.