Level of Detail, Need Help with DAX Formula, fixed to a month
Hello everyone! I am coming from Tableau (not by choice) and I am stuggling to figure out how to make the math work. Here is what my Table looks like (contains all months for the year, multiple years) I am wanting to calculate turnover for the Month, the math is = (sum[Removed]/sum[Assinged]) =9/127 and should return 7.09% How is this done in BI? Thank you for any asstiance! Month/Year Site Assigned Removed Aug-20 JNT 7 0 Aug-20 XSC 11 0 Aug-20 TOR 2 0 Aug-20 DTR 5 0 Aug-20 CHL 9 0 Aug-20 DOC1 18 1 Aug-20 DOC2 16 0 Aug-20 DOC3 21 5 Aug-20 DZC 3 1 Aug-20 ZRD 3 0 Aug-20 LCS 3 0 Aug-20 ZNT 14 1 Aug-20 GSC 5 0 Aug-20 MTO 10 1