Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Multiple IF statements in a measure

Hello Power Users, I'm having some issues while creating a DAX measure. I want to create a measure with few conditions and calculate it. Below is my data look like. MY source is SSAS tabular model...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , Try measure like

 

Measure = SUMX(table, SWITCH(TRUE(), [SHIP]="XY", [QTYYTD], [SHIP]="CA", [QTYYTD]*[COSTYTD],0) )

Anonymous's avatar
Anonymous
Not applicable
4 years ago

amitchandak Thanks for the response. That is the measure i tried but i'm getting memory exception issue. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    amitchandak Anonymous I have changed the dataload to Import mode and loaded only 2 year of data and i'm not getting memory exception issues. the measure seems right but the condition is not right because only one condition is working otherone is not working.  When i select XY its working little bit right(some rows its not matching) and when i select CA it is giving me blank. Please help