SUMX CALCULATION TOTAL

Question

Hi All&nbsp;I am new to DAX, I am using SUMX in Power Bi Desktop and created a measure named MTD Var % Sumx and the the calculation is shown below&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUMX(&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; vw_DSF_Final,&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;vw_DSF_Final[CY MTD]/vw_DSF_Final[PY MTD]-1)*100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I want the grand total to appear as -16.88 (as per above image) and this comes from the calculation as&nbsp;&nbsp;=((6065/7293)-1)*100&nbsp;But the Grand Total I am getting in Power BI is different from Excel -- see below. How do I correct the DAX calculation above to get -16.84 as the grand total for the column MTD Var % SumX&nbsp;&nbsp;&nbsp;&nbsp;

ashish_mathur · Accepted Answer

Hi,
&nbsp;
The SUMX function should not be required.&nbsp; Try this measure
&nbsp;
=vw_DSF_Final[CY MTD]/vw_DSF_Final[PY MTD]-1
&nbsp;
Format this measure as a %
&nbsp;
Hope this helps.

Forum Discussion

SUMX CALCULATION TOTAL

2 Replies

Related content

SumX? - cumulative running total

¿SumX? - Total acumulado

SUMX CALCULATION TOTAL

SumX

Incorrect Totals even with SUMX!