IF in meassure with VAR

[FilipoARG]

Hi, 

I would apreciatte some help on this. Works in my head only lol.

My table has:

- amount in units (Cantidad_Facturada)

- amount in kg (Kilos_Facturados)

- Business Unit (UEN)

I need a meassure to use different columns, depending on what UEN is:

Unidades Facturadas prueba = 
    VAR _CantFactAl = CALCULATE(SUM(Facturacion[Cantidad_Facturada]),Facturacion[UENS.UEN]="Aluminium")
    VAR _CantFactTp = CALCULATE(SUM(Facturacion[Cantidad_Facturada]),Facturacion[UENS.UEN]="Tinplate")
    VAR _CantFactPh = CALCULATE(SUM(Facturacion[Kilos_Facturados]),Facturacion[UENS.UEN]="Pharma")
    VAR _CantFactFS = CALCULATE(SUM(Facturacion[Kilos_Facturados]),Facturacion[UENS.UEN]="Food Solutions")
    VAR _CF =   IF(SELECTEDVALUE(Facturacion[UENS.UEN])="Aluminium",_CantFactAl,
                IF(SELECTEDVALUE(Facturacion[UENS.UEN])="Tinplate",_CantFactTp,
                IF(SELECTEDVALUE(Facturacion[UENS.UEN])="Pharma",_CantFactPh,
                IF(SELECTEDVALUE(Facturacion[UENS.UEN])="Food Solutions",_CantFactFS,0))))

RETURN
_CF

What am I doing wrong? doesn´t give me any error, but doesn´t give me any value also.

[v-binbinyu-msft]

Hi @FilipoARG ,

Based on your description above, it is difficult for me to determine what the problem is, please provide more detailed information, such as desensitized data and screenshots for the results you expect.

Based on your description above, I can only guess that the problem may occur in the context for the measure.

Thanks for your efforts & time in advance

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MahyarTF]

Hi,

Would you please share some data here ?