Forum Discussion
Resolver IYet another MTD question!
Community ChampionMight be wrong, bu this looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
troyhimesThanks for the links Greg, I wasn't aware of the HASONExxxxx functions.
I may not be seeing it, but I don't think it's the solution to this issue though. The Grand Total value is not used for anything, I'm just displaying it for illustration purposes in this post. My issue is with the MTD calculation.....I don't know if I'm using the correct terminology but how do I keep the row to row context when adding the daily values for the MTD calc?
As expected, the 3/1 daily BTZ Feed Ozs calc uses the row context (3/1 Btz Tons * 3/1 BTZ 30day avg) as does the MTD.
3/1 Daily=312 & MTD=312
On subsequent days (example 3/2), again as expected the 3/2 daily BTZ Feed Ozs calc uses the row context (3/2 Btz Tons * BTZ 30day avg) BUTthe MTD calc uses (Cumulative Feed Ozs * Current Row daily 30day avg ----> 3/1 + 3/2 BTZ Feed Ozs * 3/2 BTZ 30day avg)
3/2 Daily=271 & MTD=591
The daily values return 312+271=583 but my MTD value is returning 591 based on the calc above.
// Calendar must be the Date table in the model // marked as such. [BTZ Feed Ozs MTD] = sumx( DATESMTD( Calendar[Date] ), [Btz Tons] * [Btz 30day avg] )Best
D
- troyhimes
Anonymous , based on your response, my "row context" was probably incorrectly used and I am using the Date Table.
The BTZ 30day avg is a measure and here's the formulas...
BTZ Feed Ozs:=sum(Conccentrator_Final[Blitz Tons])*[BTZ 30day avg]
BTZ Feed Ozs MTD:=CALCULATE (
[BTZ Feed Ozs],
DATESMTD( 'Calendar'[Date] ),
Conccentrator_Final[Feed Oz's_2] > 0
)