Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Switch Function not calculating

Hi Experts

 

I have the following switch statement which is returnng back "no result" as opposed to the [Margin Pecent] value...

Total Margin = SWITCH(
SELECTEDVALUE('Date Calculations'[Date Calculation]), 
    "Local Margin", CALCULATE(CALCULATE(
        [Margin Percent]
        ,
        FILTER( ALL(Profitability[DIM_POSTING_DATE_SK]),
            CONTAINS( VALUES('DateFilter'[DIM_DATE_SK]),'DateFilter'[DIM_DATE_SK], Profitability[DIM_POSTING_DATE_SK] ) )
         )
,
FILTER (
        ALL ('DateFilter' ),
        'DateFilter'[Quarter Nbr] = MAX ('DateFilter'[Quarter Nbr] )
            && 'DateFilter'[Full Date] <= MAX (DateFilter[Full Date])
    )

     ),"")
  • Hi Anonymous,

    Could you please offer me some sample data to have a test and post your desired result?

     

    Regards,

    Daniel He

     

2 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee

    Hi Anonymous,

    Could you please offer me some sample data to have a test and post your desired result?

     

    Regards,

    Daniel He

     
    • Anonymous's avatar
      Anonymous
      Not applicable

      Solved it Daniel.....i was being silly. All you have to do is change the measure name and complete the function off like a normal switch statement.. thanks for looking at question