Display Only Most Recent Value?

susannataylor ,
This will give you the latest date in your table:

Latest Date = 
CALCULATE(
    MAX('Table'[Week Of]),
    ALL('Table'[Week Of])
)

This will give you the latest value for that date. You didn't specify what you meant by total. If you just mean the total of everything, then stick this measure in a card:

Grand Total = SUM(Table[PATs Waitlist])

But if you want the total for the latest date, then this works fo rthe PATs Waitlist column.

Latest Total = 
CALCULATE(
    SUM('Table'[PATs Waitlist]),
    ALL('Table'[PATs Waitlist]),
    FILTER(
        ALL('Table'[Week Of]),
        'Table'[Week Of] = [Latest Date]
    )
)

 Can you explain the logic of your desired matrix? 

EDIT: I looked at it again, and think I see what you mean. You need to fix your table in Power Query first.

1. Select the first column (week of) in Power Query.
2. On the Transform menu, select Unpivot Other Columns.
3. Rename the columns as desired. You will get this:
   1. 

       

4. Now create these two measures:

Normalized Latest Date = 
CALCULATE(
    MAX('Normalized Table'[Week Of]),
    ALL('Normalized Table'[Week Of])
)

Normalized Latest Week Total = 
CALCULATE(
    SUM('Normalized Table'[Value]),
    FILTER(
        ALL('Normalized Table'[Week Of]),
        'Normalized Table'[Week Of] = [Normalized Latest Date]
    )
)

You can create this matrix:

See my PBIX file here. You want the "Normalized Table" to work through.