DAX Measure to filter dynamically on latest date not working

[LillyLegenda]

Good morning,

I would like to show the following timeline chart next to a chart which is showing the largest partners, but only of the latest month..

As you can hopefully see: In 3-2022 the value is 0.6M but the largest partner has 2.6M.

Here is the DAX I am using for the Partner Chart:

Measure 1 Latest = 
VAR Latest = [Max Import Date]    //MAX(Report[ImportDate])
Return CALCULATE(
'Key Measures'[Measure 1],
FILTER(
Report,
Report[ImportDate] = Latest
)
)

It seems like it is working for the sum but not if I add the Partner.

I would like to be able to click on a Partner and see timeline changing for all months. Is this possible?

Do you have an idea what is wrong with my code?

Thanks!! 🙂

[V-lianl-msft]

Hi @LillyLegenda ,

How is Measure 1 calculated? The calculation of Measure 1 may cause this problem.

Could you share a sample pbix after deleting sensitive data so that we can check  the problem.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@LillyLegenda , try like

Measure 1 Latest =
VAR Latest = MAXX(allselected(Report), Report[ImportDate])
Return CALCULATE(
'Key Measures'[Measure 1],
FILTER(
Report,
Report[ImportDate] = Latest
)
)

[LillyLegenda]

Thanks for your answer but this is not helping. The latest date stored in the variable is working fine.