Forum Discussion

klajmexka's avatar
klajmexka
New Member
5 years ago
Solved

Filtering highest ID based on one unique number in direct query mode

Hello,   I'm stuggling with a solution how to filter only highest ID for each number in table. I managed to do it in offline DB however not able to make it work in direct query mode.   Let's say ...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Hi klajmexka ,

     

    Please try to create a measure like this and apply it to visual level filter.

    Measure 2 = 
var max_id = CALCULATE(MAX('Table'[ID]),ALLEXCEPT('Table','Table'[NMB]))
return IF(MAX('Table'[ID])=max_id,1,0)

     

     

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

parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

klajmexka you have to write another measure to get the note based on the highest Id.

 

Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

klajmexka's avatar
klajmexka
New Member
5 years ago

any formula suggestion please?