Forum Discussion

sbellidoBI's avatar
sbellidoBI
Regular Visitor
7 years ago
Solved

DAX nested condition

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"...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago
    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.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago
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's avatar
    sbellidoBI
    Regular Visitor
    7 years ago

    It works!! Thank you!!