Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Creating a additional field that links two existing fields together

Hi,

 

I have a field called 'Opportunity Margin', one called 'Opportunities Lost', and one called 'Opportunities Won'. I would like to create a chart displaying two seperate graphs for the won opportunity margin, and lost opportunity margin. Therefore I believe I need to create a new measure which creates an option for the opportunity margin to linked to won opportunities, and a seperate one linked to lost opportunties to achieve this. I used the following measure: 

 

CALCULATE(SUM('f Opportunity 2'[Opportunity Margin]), 'f Opportunity 2'[Opportunities Won 2] = "Won")

 

However, an error appears to say "A function 'Placeholder' has been used in a true/false expression that is used as a table filter expression". 

 

Please could someone advice on how I can achieve the intended result?

 

Thank you.

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous 

    It may be easier for people in the forum to answer the question if you provide some sample data and desired output 🙂

    The error that appears in your expression might be due to mispelling of column names. But hard to tell without seeing what you have and what you want to achive.



    Kind regards.