Forum Discussion
Alternative to SWITCH ()?
I ended up brining the role into the fact table since it was a one (access) to many (fact). It works that way but I would think there's a better way. And it is definately the SWITCH function. I tried the table with other elements and it worked fine until I added the metric using SWITCH.
Hi lfholland,
Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to danextian and Greg_Deckler for prompt and helpful responses.
Just following up to see if the responses provided by community members were helpful in addressing the issue.
If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna Kumar