How to create a measure that takes the maximum filtered date

[Syndicate_Admin]

Good Day, I have a query of a report that I am creating with respect to a measure that I want to create to be able to show the sales I make in the day, in the report I am showing the accumulated sales and I need to show the sales made in the day according to how the day segmenter is running, have a year segmenter, another of Month and one of day which is created with less than, so you can slide the same and seeing the accumulated, what I want is that the measure of daily sale to be positioned for example on day 1 to 25, show me only the sales of the day 25 not an accumulated

[Syndicate_Admin]

Thank you very much, perfect solution

[SpartaBI]

@Syndicate_Admin my pleasure 🙂 Please don't forget to accept it as a solution to help the other members find it more quickly. Appreciate Your Kudos👍

[SpartaBI · Accepted solution]

@Syndicate_Admin in case you use a date dimesntion table than it's simple as this:

Last Selected Date Sales = CALCULATE([Sales], LASTDATE('Date'[Date]))

In case it answered your question, please accept it as a solution to help the other members find it more quickly. Appreciate Your Kudos 💪
Showcase Report – Contoso By SpartaBI 
Website Linkedin Facebook 
This is SpartaBI!