Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Experts
I have a table as below, where the measures work well on their own but the totals are wrong in different ways.
After checking relevant posts here I'm sure that there must be something wrong with my coding below, but indeed don't know how to modify it, limited by my coding capability. Thanks for your help in advance!
Measures details:
Raw Table
Solved! Go to Solution.
@Anonymous , Try a measure like
sumx(values(Table[Month Year]),[Reserve@GC]-[Scrapped@GC]-[Reserve@GC-1])
@Anonymous , Try a measure like
sumx(values(Table[Month Year]),[Reserve@GC]-[Scrapped@GC]-[Reserve@GC-1])
Thanks Amit like always.
The one with your new measure now looks good.
But the highlighted column still return the value of the top row. I guess a SUMX shall fix it too, but tried couple of times and see all failed.
The details of this measure
Reserve@GC-1 = CALCULATE(SUM(TotalReserve[Total Value (GC)]),PREVIOUSMONTH('TIME'[MonthDate]),TotalReserve[Type]="Reserve")
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
96 | |
96 | |
67 | |
59 |