topic Re: DAX Measure to filter dynamically on latest date not working in DAX Commands and Tips

DAX Measure to filter dynamically on latest date not working

LillyLegenda — Wed, 02 Mar 2022 13:29:13 GMT

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!! 🙂

Re: DAX Measure to filter dynamically on latest date not working

amitchandak — Wed, 02 Mar 2022 14:36:44 GMT

LillyLegenda , try like

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

Re: DAX Measure to filter dynamically on latest date not working

LillyLegenda — Wed, 02 Mar 2022 15:48:21 GMT

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

Re: DAX Measure to filter dynamically on latest date not working

V-lianl-msft — Mon, 07 Mar 2022 06:53:02 GMT

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.