Show Total in Stacked column chart

[prateekraina]

Hi Everyone,

Please look into the issue i have been facing below and help:

I have two tables with data as follows:



I have created a mesaure which calculates Total consumption by month so that i can put it in "Tooltips" of Stacked column chart to show totals across month.



Below is the dax used:

TotalByMOnth = SUMX(SUMMARIZE('Month','Month'[MONTH],"Total",
CALCULATE(SUM(ConsumptionFact[Consumption]))),[Total])

I am not able to get desired result. Can anyone suggest any fix in the DAX used?

[Anonymous]

Would this work for you?

TotalByMOnth = TOTALMTD(
	SUM(ConsumptionFact[Consumption]),	
	ConsumptionFact[Dates]
)

[prateekraina · Accepted solution]

Hi @Anonymous,

Thanks for trying buddy. It did not give the desired result though.

I found the hint of solution by using Quick Measures option. The requried DAX is

TotalByMonth = 
CALCULATE(SUM('ConsumptionFact'[Consumption]), ALLSELECTED(ConsumptionFact[Meter]))