Forum Discussion

Rinn's avatar
Rinn
Frequent Visitor
2 years ago
Solved

Optimized DAX (SUMX and SUMMARIZE)

Hi, I am trying to optimize my DAX measure because it is too slow on Service BI...   To sum up, I am trying to calculate the total sales (%) for each customized category (A, B etc...) of my prod...
  • sjoerdvn's avatar
    sjoerdvn
    2 years ago

    No need for a SUMX I think, try this:

    Total sales Category A % = 
CALCULATE(SUM ( 'Products Sales'[Sales Unit] ), FILTER(VALUES( 'Products'[Category]), [Created Category Measure] = A))
/ SUM ( 'Products Sales'[Sales Unit] )
sjoerdvn's avatar
sjoerdvn
Icon for Solution Sage rankSolution Sage
2 years ago

No need for a SUMX I think, try this:

Total sales Category A % = 
CALCULATE(SUM ( 'Products Sales'[Sales Unit] ), FILTER(VALUES( 'Products'[Category]), [Created Category Measure] = A))
/ SUM ( 'Products Sales'[Sales Unit] )