Same as Previous using Fiscal Week Numbers

[apmulhearn]

Hello,

I have a chart visual working well for me in my Dashboard, but I need to make a Card which summarizes some of that data. I am struggling here. Below is an image of the items I'm working with.

"Weekly Booked Guests Totals" on the left summarizes weekly booked guests on the current year week end date, and shows me bookings for that same week number, historically.

However, I assume because of the "MAX" application in the measure I'm using, it is only returning 41 (the booked guests for the MAX week number in 2019.)

This is the measure I used to get the figures in the chart, which is working for me.

Guests booked 2 yrs ago = CALCULATE(sum('Invoices - Pmt Date'[Booked Guests (Primary Booking) (Booking)]),filter(all('date table'),'Date Table'[Week Rank]=max('Date Table'[Week Rank])-104))

I want the yellow multi-row card to summarize those totals correctly.

What can I use?

Thank you,

Amanda

[amitchandak]

@apmulhearn , Try measures like

suxm(values(Table[Week end]),[Guests booked 2 yrs ago])

[apmulhearn]

Thank you so much for trying to help me, but I think I am misunderstanding something. The Week End Date comes from a Date Table, and the Guests Booked 2 Yrs Ago Come from an Invoice Table. It looks like SUMX is designed to work on 1 table. Am I getting something wrong here?  

Thank you.