From Tableau Fixed function to Power BI DaX

Hi Daxmon_23 ,

Change your formula like below:

Cump =
VAR a =
    SWITCH (
        TRUE (),
        [Precio Prom] < 450, "0-$450",
        AND ( [Precio Prom] > 450, [Precio Prom] <= 550 ), "$500",
        AND ( [Precio Prom] > 550, [Precio Prom] <= 650 ), "$600",
        [Precio Prom] >= 600, "More than $600"
    )
RETURN
    CALCULATE (
        a,
        ALLEXCEPT ( Sales, Sales[UniqueID] ),
        ALLEXCEPT ( Product, Product[Categories] )
    )

or maybe:

Cump =
VAR a =
    SWITCH (
        TRUE (),
        MAX ( DimProduct[Color] ) = "Red", "red",
        AND (
            MAX ( DimProduct[Color] ) = "Black",
            ( MAX ( DimProduct[Color] ) = "Grey" )
        ), "grey",
        "Other color"
    )
RETURN
    CALCULATE ( a, ALLEXCEPT ( DimDate, DimDate[FiscalYear] ) )

If the problem is still not resolved, please provide detailed error information and test data. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.