Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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]) ) ),"")
Solved! Go to Solution.
Hi @Anonymous,
Could you please offer me some sample data to have a test and post your desired result?
Regards,
Daniel He
Hi @Anonymous,
Could you please offer me some sample data to have a test and post your desired result?
Regards,
Daniel He
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
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |