Switch Function not calculating

[Anonymous]

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])
    )

     ),"")

[v-danhe-msft · Accepted solution]

Hi @Anonymous,

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

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

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

Regards,

Daniel He

[Anonymous]

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