Forum Discussion

NutNick1982's avatar
NutNick1982
Helper I
6 years ago
Solved

Marking first instance for multiple items

Hi PowerBI Community! I have a question that hopefully someone can help me out with. I need to mark the first instance  when a “job” goes to 100% complete. There are multiple jobs in the dataset and...
General Comment
Need Help
Tips and Tricks
  • parry2k's avatar
    parry2k
    6 years ago

    NutNick1982 solution attached

     

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.⚡

parry2k's avatar
parry2k
Super User
6 years ago

NutNick1982 add a new meaure like this

 

First Reached to 100% = 
VAR __date = CALCULATE ( MIN ( Table[Date] ), ALLEXCEPT ( Table, Table[JobId] ), Table[PerentComplete] = 1 )
RETURN
IF ( __date = CALCULATE ( MIN ( Table[Date] ), ALLEXCEPT ( Table, Table[JobId] ), Table[PerentComplete] = 1 ), "Yes" )

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.⚡

NutNick1982's avatar
NutNick1982
Helper I
6 years ago

Thank you for your reply. I'm getting "Yes" for all results.

Results in my Table:

Measure that I input: