Forum Discussion

Saranya_Tamil's avatar
Saranya_Tamil
Frequent Visitor
3 years ago
Solved

Need help in DAX

I need to figure out whether the Deal is a S4U or not. The logic is if other than S4U in 'Name' field has S4U as family then it is a S4U deal. For ex, here 1 is not S4U bcz other than S4U no one ...
Need Help
  • rsbin's avatar
    rsbin
    3 years ago

    Saranya_Tamil ,

    Add this as a second Calculated Column:

    Output = SWITCH(
             TRUE(),
             CALCULATE( SUM([S4UDeal] ),
                  ALLEXCEPT( 'Deals (2)', 'Deals (2)'[Deal] )) > 0, "Yes",
                  "No" )

    If you want, you can probably combine both into just one column.

    Regards,

rsbin's avatar
rsbin
Community Champion
3 years ago

Saranya_Tamil ,

Add this as a second Calculated Column:

Output = SWITCH(
             TRUE(),
             CALCULATE( SUM([S4UDeal] ),
                  ALLEXCEPT( 'Deals (2)', 'Deals (2)'[Deal] )) > 0, "Yes",
                  "No" )

If you want, you can probably combine both into just one column.

Regards,

Saranya_Tamil's avatar
Saranya_Tamil
Frequent Visitor
3 years ago

Thank you rsbin , it works 🙂