please delete this thread and option for solution

Sorry, I've too quick assumed I did good calculation, please remove this solution

Create a calculate table with maximum date and maximum value

ribisht17
Super User
4 years ago
Pbiuserr
This should work
Step1
Max Date per ID= calculate(max(date),allexcept(table,ID))

Step2
Max Val per ID=calculate(max(Value),allexcept(table,ID))

Step3
IF(AND(Max Date per ID=Date,Max Val per ID-Value),true(),false()) //drag this to Filter and select true

Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users
- Pbiuserr
  Post Prodigy
  4 years ago
  Hey. Would it work on calculate table as well?
  - ribisht17
    Super User
    4 years ago
    Not a great way to seek help, community posts are for everyone , you have made it look awkward now.At-least you would have pasted your solution /or accpeted mine as the solution if you made use of the same
Pbiuserr
Post Prodigy
4 years ago
Sorry, I've too quick assumed I did good calculation, please remove this solution