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?
Hi PaulDBrown,
Thanks , this actually somewhat worked. Can you please explain what the qwuery is actually doing as that would be helpful for me to learn.
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?