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?