Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Using Lookupvalue in a Measure with two variables based on two measueres

Hi everybody,   I need your held lease. I would like to lookup a value in different table (Is not connected to any table in data modell, because it doesnt primary key) based on two criteria. Those...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    What you are trying to create is a calculated column or measure? And are the variables VAR Prod=Produktivität and VAR Std_to=Nacharbeitsaufwand measures or the fact fields of the table? Could you please provide some sample data in Table1(exclude sensitive data) and your expected result with logic and special examples? Thank you.

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

What you are trying to create is a calculated column or measure? And are the variables VAR Prod=Produktivität and VAR Std_to=Nacharbeitsaufwand measures or the fact fields of the table? Could you please provide some sample data in Table1(exclude sensitive data) and your expected result with logic and special examples? Thank you.

Best Regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous 

     

    I ´m trying to create a calculated measure. The variables VAR Prod= Productivity & VAR Std_to=Quote Rework are measures.

    Those two measures are based on star schema with many tables.

    Test is the final measure, which doesn´t work.

    The result I need can be found in table Bonus. The column is called Bonus as well.

    E.g. Februar:

    Prouctivity: 93,68% à 94%

    Quote Rework: 0,10

    Test: 20,61375

     

    Mai:

    Productivity: 107,26% à 107%

    Quote Rework: 0,10

    Test: 19,7175

     

    Thanks for your help!

    Tendo