Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Project Milestones Filter

I want to create a measure to show which milestone my project is on through Power BI. I've created a table which has the milestone, start date and end date. It will refresh once a week to move projec...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Anonymous 

    Please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.

     

     

    Milestone Flag =
    CALCULATE (
    SELECTEDVALUE ( Milestone[Milestone] ),
    FILTER (
    Milestone,
    Milestone[Start] <= MAX ( 'Calendar'[Date] )
    && Milestone[End] >= MIN ( 'Calendar'[Date] )
    )
    )

     

     

    https://www.dropbox.com/s/7z7qg9wmicykzh3/Gingerclaire.pbix?dl=0 

     

    Hi, My name is Jihwan Kim.

     

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

     

    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, Anonymous 

Thank you for sharing the data.

Please check the below picture and the pbix file's link down below whether I understood your question correctly.

I think you can use the below measures to calculate the percentage, for instance.

 

https://www.dropbox.com/s/flfsc77ijnu27g5/SampleFile.pbix?dl=0 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Jihwan_Kim Thank you - I've been able to work it out on the sample data set and get the correct calculations.

 

However, when I replicate the measures on my real data I can't get the 'parts finished' correct. It just comes up with the total in each row and not 1 as on the sample dataset. As a result I can't filter to the different milestone. Any thoughts why it might do that? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

     

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Super User
      5 years ago

      Hi, Anonymous 

      Thank you for sharing.

      If it is OK with you, please share your sample pbix file's link, then I can try to look into it.

      I think it is because of the relationship between the two tables, but I need to check, if possible.

       

      Thank you.