Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
96 | |
75 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |