Forum Discussion

al1ceDav1n's avatar
al1ceDav1n
Regular Visitor
3 years ago

SWITCH STATEMENT NOT WORKING

Hi   Could some one help with the below SWITCH statement? Thanks in advance   Volume = SWITCH( 'RTY_UY'[EFFECT DATE] and 'TYU_JP' [REMAINING_FLAG] = "N", 0 ('RTY_UY'[EFFECT DATE] and 'TYU_JP' [RE...
al1ceDav1n's avatar
al1ceDav1n
Regular Visitor
3 years ago

Hi Thanks for your reply 

The Effective date is needed to work out the COUNT for INT_ID - 

I have tried this but still no good 

Any other idea's much appreciated 

 

  • mlsx4's avatar
    mlsx4
    Icon for Memorable Member rankMemorable Member
    3 years ago

    But then, include it in the calculate part. Something like this:

    Volume = 
var selectedDate= SELECTEDVALUE('RTY_UY'[EFFECT DATE])

RETURN SWITCH( 'TYU_JP' [REMAINING_FLAG],
"N", 0,
"Y",CALCULATE(COUNT([INT_ID]),DimDate= selectedDate), 
CALCULATE(COUNT([INT_ID]),DimDate= selectedDate))

     

    • al1ceDav1n's avatar
      al1ceDav1n
      Regular Visitor
      3 years ago

      Hi,

      For some reason dislikes the "Y" so close 

      Thanks 

      • mlsx4's avatar
        mlsx4
        Icon for Memorable Member rankMemorable Member
        3 years ago

        Hi al1ceDav1n 

         

        I don't understand what's happening. Maybe you need to put a SELECTEDVALUE('TYU_JP' [REMAINING_FLAG]). It is really difficult to figure out the problem without having any information about the structure, the input, the output...