Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Need help in dax

Hello there,

 

I am looking for help in Dax, I need to perform aggregation(sum) based on the product with an explicit filter condition.

 

Sample Data:

ProductValueTrendy
Apple2000Yes
Apple3000No
Orange1000Yes
Orange2000No
Mango1000Yes
Mango1000No

 

eg: for apple , I should sum where trendy="Yes", 

for orange, I should show sum where trendy="No",

else just sum

 

Expected Result:

ProductSales
Apple2000
Orange2000
Mango2000

 

I have tried something like this but not getting the expected result.

Measure = sumx(Sheet1,SWITCH(TRUE(),Sheet1[Product]="Apple"&&Sheet1[Trendy]="Yes",Sheet1[Value],
Sheet1[Product]="Orange"&&Sheet1[Trendy]="No",Sheet1[Value],
Sheet1[Value]))
 
Kindly let me know if we are able to achieve this in Dax.

 

General Comment
Need Help
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try like

    Measure = sumx(Sheet1,SWITCH(TRUE(),Sheet1[Product]="Apple" && Sheet1[Trendy]="Yes", Sheet1[Value],
    Sheet1[Product]="Orange" && Sheet1[Trendy]="No",Sheet1[Value],
    Sheet1[Product] in {"Orange","Apple"} , blank(),
    Sheet1[Value])
    )

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , Try like

    Measure = sumx(Sheet1,SWITCH(TRUE(),Sheet1[Product]="Apple" && Sheet1[Trendy]="Yes", Sheet1[Value],
    Sheet1[Product]="Orange" && Sheet1[Trendy]="No",Sheet1[Value],
    Sheet1[Product] in {"Orange","Apple"} , blank(),
    Sheet1[Value])
    )