Measures to display % of projects by date and percentage chance to win
Hello! I have been struggling with this task for a while now and i decided to ask for help. I have table with estimated cost, project name, date and percentage that project will be won.
I would like to create 3 different measures in one line chart
One which shows estimated cost of 50% of all projects by date and highest percentage change
Another line chart which shows estimated cost for 75% of the projects by date and highest percentage change and third line chart which shows estimated cost for all projects by date
All columns are in one table. For example if we used example picture, the 50% estimate would show estimated cost of project a and project b, because they are 50% of all projects with higest percentage.