Arithmetic expression using Select()

[AlejandroCamach]

Hi,

I’m trying to make a Valid_if function to restrict the maximum value from another table. I have the following formula:

MAX(SELECT(GLOSARIO INVENTARIO[Máximo], AND([_THISROW].[Frecuencia] = [Frecuencia], [_THISROW].[Punto de venta] = [Lugar], [_THISROW].[Momento] = [Momento])))

It says the formula is ok but it is not a expected Valid If condition. Any thoughts?

[LeventK · Accepted solution]

@AlejandroCamacho
Valid_if needs to evaluate to a TRUE/FALSE value. You can maintain this simply:

[_THIS]<=MAX(SELECT(GLOSARIO INVENTARIO[Máximo], AND([_THISROW].[Frecuencia] = [Frecuencia], [_THISROW].[Punto de venta] = [Lugar], [_THISROW].[Momento] = [Momento])))

[AlejandroCamach]

LeventK:

[_THIS]<=MAX(SELECT(GLOSARIO INVENTARIO[Máximo], AND([_THISROW].[Frecuencia] = [Frecuencia], [_THISROW].[Punto de venta] = [Lugar], [_THISROW].[Momento] = [Momento])))

Perfect! Worked great, thanks guys!

[LeventK]

@AlejandroCamacho
Can you please mark my reply as solution? It might be useful for other community members as well if and when they search the community posts with the solution tag. Thank you.

[AlejandroCamach]

Done, sorry… didn’t knew there was a button for it. Thanks again!

[LeventK]

@AlejandroCamacho
Not a big deal, but you had marked your own reply

[AlejandroCamach]

Haha still so much to learn!

[adambc]

It looks like the Select function is expecting a select-row? for the second parameter but you are providing AND which returns Yes/NO