Hi this is what I have so far
Solved! Go to Solution.
You can use && instead of AND().
BalanceScore = Switch( True(), [Shift1]=[Shift2] && [Shift1]=[Shift3] && [Shift1]=[Shift4] && [Shift1]=[Shift5]) , 3, 1)
But It is not necessary to use Switch, you use switch when you want more 2 results.
BalanceScore = IF([Shift1]=[Shift2] && [Shift1]=[Shift3] && [Shift1]=[Shift4] && [Shift1]=[Shift5]), 3 ,1)
How to use Swtich: https://docs.microsoft.com/en-us/dax/switch-function-dax
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This is a must watch for a message from Power BI!
Click here to read more about the December 2020 Updates!
Click here to read the latest blog and learn more about contributing to the Power BI blog!
Mark your calendars and join us for our next Power BI Dev Camp!.