I need a help or advice. In pictures below y...

[Sumar_BP]

I need a help or advice.

In pictures below you can see that two sheets are ref. My question is: is it possible that the last offered choice

(in this case number 4), select by itself, because there is always only one choice?

[Aleksi_Alkio]

Something like this for the initial value field… ANY(SELECT(TableName[Column],AND([GROUP]=[_THISROW].[GROUP],[VALUE]=[_THISROW].[VALUE])))

[Harry2]

Have you tried using the column’s Initial Value expression?

[Sumar_BP]

Jes I have but

this

column have more than one choice.

Aleksi Alkio a will try that formula. Tkanks!

[Sumar_BP]

I can not figure out how to write a formula. In coment below I attach pictures of tables. If someone can help me I will be grateful.

This is the first table where I need that column “bonitet” chose value for itself.

[Sumar_BP]

This is second table where is the value of column “bonitet”

[Aleksi_Alkio]

ANY(SELECT(TableName[BONITET],AND([ODSJEK]=[_THISROW].[ODSJEK1],[VRSTA]=[_THISROW].[VRSTA]))) Translate

[Sumar_BP]

Thank you very much. This formula works.

[Aleksi_Alkio]

You’re welcome