3 Tips to use SUMX() in Power BI — Ways to Master DAX

3 ways to use SUMX() in DAX.

There are 3 common ways to use SUMX().

1. Calculate distincount.
   By using SUMX() to calculate distinct count, would get better performance.
   [1.不重複計數#]= SUMX(VALUES(_retail_table[seq],1)
2. Calculate Sales Amount.
   By using SUMX() would calculate value row by row, then sum up result at end. This is also the classic way to use SUMX().
   [2.銷額加總#] = SUMX(_retail_table, [sales_price] * [qty])
3. Condition Calculate with VAR.
   This would be a advanced tip to use.
   By calculate condition criteria row by row, then sum up result at end.
   [3.條件銷額加總#] =
   SUMX(_retail_table,
   VAR _sales_price = [sales_price]
   Return
   SWITCH(TRUE()
   , _sales_price >2, [sales_price] * [qty]
   , 0
   )

Learn more from my LinkedIn if you also interest in Power BI and DAX.

Frank Lin - Marketing BI Developer - 寶雅國際股份有限公司 | LinkedIn