I am still very new to Power Pivot & DAX Measures, so a little help would be greatly appreciated here!
I have the below table:
I am trying to build a DAX measure that will return the latest [Universe] value. I have tried a combination of CALCULATE, MAX, FILTER, EARLIER, but am struggling to get the desired output, as seen below.
I don't necessarily want the outputs in a table, but rather in a measure because I want to use it in a calculation.
Note, this is my current attempt:
Total Universe:=SUM([Universe])
Last Universe Date:=CALCULATE(MAX([Date]),FILTER(tbData,LASTNONBLANK(tbData[Universe],1)))
Last Universe Value:=CALCULATE([Total Universe],FILTER(tbData,tbData[Date]=[Last Universe Date]))
Last Universe Date returns the correct date, but Last Universe Value returns the Grand Total value.
Any help/ guidance is appreciated.

