cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Route11 Member
Member

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

     ),"")
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Switch Function not calculating

Hi @Route11,

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

 

Regards,

Daniel He

 
Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Switch Function not calculating

Hi @Route11,

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

 

Regards,

Daniel He

 
Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Route11 Member
Member

Re: Switch Function not calculating

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