Forum Discussion

MDodds's avatar
MDodds
Resolver II
3 years ago

Filter interacting with DAX Measure

Hi guys,   I am some Xero data pulling to report and a measure that displays the latest invoice amount which I then slice with customer data.   DAX measure below:       Last Invoice Amount =...
Need Help
djurecic's avatar
djurecic
Super User
3 years ago

Hi MDodds ,

 You can try using FILTER ( ALL(Dates), Dates[Date] = LastSalesDate )

  • MDodds's avatar
    MDodds
    Resolver II
    3 years ago

    Thanks djurecicK2.

    This is about half way there. If I can't solve it fully I will go with this solution.
    This displays the most recent invoice in the data, but essentially ignores the slicers. I want it to still operate with the slicers, so if I select FY2022 for example, it shows the last invoice in that year, not the last invoice in the full dataset.