Forum Discussion
Anonymous
7 years agoNot applicable
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-msftMicrosoft Employee
Hi Anonymous,
Could you please offer me some sample data to have a test and post your desired result?
Regards,
Daniel He
- AnonymousNot 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