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

[Anonymous]

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 two criteria are calculated in two measures. They are called Produktivität & Nacharbeitsaufwand.

I have created a new measure in which I want to use lookupvalue to get my value.

Measure:

VAR Prod=Produktivität

VAR Std_to=Nacharbeitsaufwand

VAR Value= lookupvalue(Table1 [Prämie];Table1 [Produktivität(%)];Prod;Table 1[Nacharbeit (h)];Std_to)

Return=Value

Unfortunately, it doesn´t work.

Does anybody has an idea why or can give my some solutions.

Thanks to everybody!!

Tendo

[Anonymous · Accepted solution]

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]

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

[Anonymous]

Link for the data set: https://daten.roemheld-moelle.de/s/gmfLnpGgkmpWLjs

PW:F7oAWCXLP9

[Anonymous]

The syntax should work?

[Anonymous]

Hi @Dinesh_Suranga ,

decimal.

[Dinesh_Suranga]

@Anonymous 

Hi,

what is the data type in value column.

[Dinesh_Suranga]

@Anonymous 

Try SelectedValue DAX function.

If you want any help for the function please reply to this message.

Thank you.

[Anonymous]

@Dinesh_Suranga 

How would it work with selectedvalue?