Forum Discussion
Model Relationship
SWITCH is a function used in measures /calculated columns wich is essentially nested IFs executed in order. So the measure in this case is checking the filter context (established by SELECTEDVALUE) and returning the corresponding measure. So the first statement checks whether the conext is "A1" and if true returns the measure [M1] and so on...Make sense?
FaisalImam , Not very clear
measure like
a1 = calculate(sum(Table[March Month]) , Filter(all(Table[Level]) Table[level] ="a1") )
a2 = calculate(sum(Table[March Month]) , Filter(all(Table[Level]) Table[level] ="a2") )
No Actually you did not get my point.
The table , I have shown is how it will be coming on the dashboard.
Column1- Key Service Level ( has all static values in table1 )
Column 2 - Month( has values calculated from another table - table 2 in which everymonth data will be refreshed)
My problem : I am unable to put the values that I have calculated in the right row because we don't have any relation..
Example :
Table 1
| Key Service | Expected |
| A1 | 95% |
| A1.1 | 65% |
| A2 | 90% |
Table 2 :
| inc | time | period |
| sghdf | 7 | 4 |
| srwetbnjl | 9 | 1 |
| sdgyfumbm | 4 | 2 |
Now from table 2 ,I have calculated several measures let it be M1,M2,M6
Now how it needs to be viewd on dashboard:
| key service level | expected | Measures |
| A1 | 95% | M1 |
| A1.1 | 65% | M6 |
| A2 | 90% | M2 |
What logic to use top have such relation. We don't have any relation between measures and the key service level.