By default formula not working in total

[PKGARG]

HI To All

I have data MonthWise. Its working when i see monthwise but when i see product overall then its show total not using formula to accumulate data. e.g.

Month  Current Year  Last Year  Growth

Apr        1000             700           42.86%

May       1500             1800        -16.67%

Jun        2000             1800          11.11%

Total     4500             4300         37.30% , but it should be  4.65%

[Phil_Seamark]

Hi @PKGARG

I think you need to use a SUMX function for your Growth measure.

Have a read of this blog, especially the part near the bottom when it talks about handling totals using DAX Iterators.

http://exceleratorbi.com.au/sum-vs-sumx-in-dax/

[PKGARG]

IN DATABASE I HAVE DATA MONTHWISE OF TWO YEAR. I HAVE CREATED A NEW COLUMN IN PI DESKTOP FOR GROWTH WITH FORMULA GROWTH = (CURRENT YEAR - LAST YEAR)/ LAST YEAR.

NOW IN DASHBOARD WHEN I SEE DATA MONTHWISE ITS OK, BUT WHEN SUMMARISED IT SHOW TOTAL OF ALL MONTH GROWTH

[v-qiuyu-msft · Accepted solution]

Hi @PKGARG,

In your scenario, if you use calculated column (FORMULA GROWTH = (CURRENT YEAR - LAST YEAR)/ LAST YEAR), it will add all FORMULA GROWTH on Total level just like the total for Current Year and Last Year.

To achieve your requirement, please create a measure like below:

Growth = CALCULATE(SUM(Table2[Current Year])-SUM('Table2'[Last Year]))/SUM(Table2[Last Year])

Best Regards,
Qiuyun Yu

[PKGARG]

Yes This is my Solution.

Thank You Very Much.

Please always help me, i am new and want everything in simple way like this.