try this code :
Rev SWLY2 = VAR _weekid52 = MAX ( DateTable[WeekID] ) - 52 RETURN SUMX ( VALUES ( DateTable[WeekEnding] ), CALCULATE ( SUM ( 'Fact Table'[Revenue Net] ), FILTER ( ALL ( DateTable ), DateTable[WeekID] = _weekid52 ) )
@mcornfield SELECTEDVALUE only return a single value and at the grand total there are no filters so you have to use MAX or MIN like this:
Rev = VAR MaxDate = CALCULATE ( MAX ( DateTable[WeekID] ), FILTER ( VALUES ( Dates[Calendar Year Number] ), [Revenue Net] <> 0 ) ) VAR Result = CALCULATE ( [Revenue Net], DateTable[WeekID] = MaxDate - 10, REMOVEFILTERS ( DateTable ) ) RETURN Result
try this formula
Rev SWLY2 = var _weekid52 = SELECTEDVALUE(DateTable[WeekID]) - 52 return CALCULATE(SUM('Fact Table'[Revenue Net]), FILTER(ALL(DateTable), DateTable[WeekID] =_weekid52 ))
Hi @mcornfield , you need use SUMX and Summarize in another measure.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.