DAX nested condition

Question

Hi everyone,&nbsp;&nbsp;I have a problem with this measure. I'm trying to calculate&nbsp; 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.&nbsp;If the conditional is "1", I want it to divide&nbsp;(1,Consolidado[PTC P0.TC])If the conditional is "0", I want it to divide (1,Consolidado[PTC Real-Estimado.TC])))&nbsp;&nbsp;VentaC$ RE P0 = SUMX(Consolidado,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CALCULATE([Venta MN],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Consolidado[FUENTE]="REAL/ESTIMADO")&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; *if('Consolidado'[TipoCampaña]="1",divide(1,Consolidado[PTC P0.TC]),DIVIDE(1,Consolidado[PTC Real-Estimado.TC])))&nbsp;PBI accepts the measure but&nbsp;there's an error when I try to use it.&nbsp;&nbsp;Any suggestions??&nbsp;Thanks,&nbsp;Sol

greg_deckler · Accepted Answer

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.

Forum Discussion

DAX nested condition

2 Replies

Related content

Conditional Formatting using DAX

Conditional formating using DAX

DAX Switch & nested IF

DAX Query Performance vs Nested Measures

Nested IF