Forum Discussion
Project Milestones Filter
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 I've added to the sample file you originally sent me - thanks! I hope it explain further what I'm trying to do.
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
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?
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.