I have two dax code below working perfectly,
Current Week Amt =
VAR CurrentFiscalWeek = MAX( 'DF'[Fiscal Week num] )
RETURN
CALCULATE(
[Measure],
'DF'[Fiscal Week num] = CurrentFiscalWeek
)
Current Week Amt_2 =
SUMX(
SUMMARIZE('DF', 'DF'[Source],
"fixed" ,[Current Week Amt]),
[fixed])
yet the first one is not giving the right totals. Because Fiscal Week num
differs. I change the Current Week Amt_2
for each table that I have. but i was wondering if there is a way to leverage VAR CurrentFiscalWeek = MAX( 'Inventory'[Fiscal Week num] )
so the table total may come correctly ? many thanks in advance.
Source Fiscal Week num
Company A 52
Company B 49
Company C 48