DAX nested condition

[sbellidoBI]

Hi everyone, 

I have a problem with this measure. I'm trying to calculate  SUMX of a column "VENTA MN" and depending on a conditional of the column "TipoCampaña", where the options are "0" or "1", calculate the second part.

If the conditional is "1", I want it to divide (1,Consolidado[PTC P0.TC])

If the conditional is "0", I want it to divide (1,Consolidado[PTC Real-Estimado.TC])))

VentaC$ RE P0 = SUMX(Consolidado,
                                  CALCULATE([Venta MN],
                                         Consolidado[FUENTE]="REAL/ESTIMADO")
                                                *if('Consolidado'[TipoCampaña]="1",divide(1,Consolidado[PTC P0.TC]),DIVIDE(1,Consolidado[PTC Real-Estimado.TC])))

PBI accepts the measure but there's an error when I try to use it.

Any suggestions??

Thanks, 

Sol

[Greg_Deckler · Accepted solution]

VentaC$ RE P0 = SUMX(Consolidado,
                                  CALCULATE([Venta MN],
                                         Consolidado[FUENTE]="REAL/ESTIMADO")
                                                *if('Consolidado'[TipoCampaña]=1,divide(1,Consolidado[PTC P0.TC]),DIVIDE(1,Consolidado[PTC Real-Estimado.TC])))

Try that. The error you are getting is that you are trying to compare a numeric value to a text value.

[sbellidoBI]

It works!! Thank you!!