How to pass the another table values to measure and the values should change dynamically

[Yuvaraj]

Hi

I have to pass the values to dynamically to column values, here i have set the static value to Sheet1 table but I need to set the dynamic values instead of static range.

For Example:

Static Range:

ComplexityLevel = if(Sheet1[Page]<=500 && Sheet1[Gadget]<=0 && Sheet1[File]<=0 && Sheet1[Drive ]<=0,"1",
if(Sheet1[Page]<=900 && Sheet1[Gadget]<=0 && Sheet1[File]<=25 && Sheet1[Drive ]<=20,"2")

Expecting Result:

Consider i have new table it contains Page,File,Drive with values columns from here we enter the values manully , if we change range values again i need to update the values in above formula manully.

Is there any chance to call directly that new table like below expression

ComplexityLevel = if(Sheet1[Page]<=New[Row1 Page value ]&& Sheet1[Gadget]<=New[Row1 Gadget value] && Sheet1[File]<=New [Row1 File value] && Sheet1[Drive ]<=0,"1",
if(Sheet1[Page]<=900 && Sheet1[Gadget]<=New[Row1 Gadget value]&& Sheet1[File]<=New[Row2 File value]&& Sheet1[Drive ]<=New [Row2 Drive value],"2")

[v-piga-msft]

Hi @Yuvaraj,

Have you solved your problem? 

If you have solved, could you share your solution or always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best  Regards,

Cherry

[v-piga-msft]

Hi @Yuvaraj,

Could you create the relationship between the tables?

Then you could use Related function to reference the value in another table such as:

ComplexityLevel = if(Sheet1[Page]<=Related (New[Row1 Page value ])
&& Sheet1[Gadget]<=Related (New[Row1 Gadget value] )......

If you still need help, please share some data sample which could reproduce the scenario and your desired output so that we could help further on it.

Best Regards,

Cherry