Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Conversion Rate over Milestones

Hello all!   I want to create a measure to get the conversion rate of my projectos.   For that, I have a table with my projects: ID Project Name Net Sales 1 Project1 20 2 Project2 ...
Need Help
Show and Tell
amitchandak's avatar
amitchandak
Super User
6 years ago

create a new column in the project table like

final Sales = if( sumx(filter(milestones,milestones[Project ID] =projects[Project ID] && milestones[Milestone Name] in {"	Milestone1","	Milestone2"} ),milestones[%]) =200, [Net Sales],0)

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank for your help amitchandak, I managed to make it work.

     

    But, can I complicate it a little?

     

    Project1 needs to have Milestone1 and Milestone2 100% to enter in the sum.

     

    However, project2 only needs Milestone1 100% to enter in the sum.

     

    How can I make this kind of differentiation?