DAX Code re-running sub total rather than summing

Question

we have a dax code that runs to calculate revenue variance when we look at the sub total&nbsp;the dax code is re running the equation rather than summing the values with in that catagory&nbsp;&nbsp;CY_QTYPY_QTY&nbsp;CY_REV&nbsp;&nbsp;PY_REV&nbsp;&nbsp;CYavgREV&nbsp;&nbsp;PYavgREV&nbsp;&nbsp;REV-var&nbsp;SuB Total A+B+C150425&nbsp;£&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 65,000&nbsp;£&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 180,000&nbsp;£&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 433&nbsp;£&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 424&nbsp;£&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,471Product A100350&nbsp;£&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 25,000&nbsp;£&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 75,000&nbsp;£&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 250&nbsp;£&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 214&nbsp;£&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3,571Product B050&nbsp;£&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;£&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 60,000&nbsp;£&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;£&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,200&nbsp;£&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;Product C5025&nbsp;£&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40,000&nbsp;£&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 45,000&nbsp;£&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 800&nbsp;£&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,800-£&nbsp;&nbsp;&nbsp;&nbsp; 50,000CY_Qty PY_Qty and CY_REV and PY_REV are calulated from summarised data table.CY_avgRev and PY_avgREV are measures that calculate Rev/QtyREV Var is a measure of sumx (( CY_avgREV - PY_avgREV) * CY_Qty)&nbsp;We have looked through other forums and couldn't find other people with a similar issue and we have looked through the settings for sub totals and none of the changes work!&nbsp;Thanks&nbsp;&nbsp;&nbsp;

v-xuding-msft · Accepted Answer

Hi&nbsp;Gareth_Hunt&nbsp;,
&nbsp;
Please use SUMX function to have a try.
Measure = SUMX(your_table,the_measure_need_to_be_summed)
&nbsp;

	CY_QTY	PY_QTY	CY_REV	PY_REV	CYavgREV	PYavgREV	REV-var
SuB Total A+B+C	150	425	£ 65,000	£ 180,000	£ 433	£ 424	£ 1,471
Product A	100	350	£ 25,000	£ 75,000	£ 250	£ 214	£ 3,571
Product B	0	50	£ -	£ 60,000	£ -	£ 1,200	£ -
Product C	50	25	£ 40,000	£ 45,000	£ 800	£ 1,800	-£ 50,000

Forum Discussion

DAX Code re-running sub total rather than summing

2 Replies

Related content

Running sum

Re-Run from failed activity re-runs also skipped acitivties

Filtering a Sum

Improper Sum with slicer

SUM