Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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]))
Would this work for you?
TotalByMOnth = TOTALMTD( SUM(ConsumptionFact[Consumption]), ConsumptionFact[Dates] )
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]))
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |