Level of Detail, Need Help with DAX Formula, fixed to a month

[Anonymous]

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

[mahoneypat]

Please try this measure expression

Turnover = DIVIDE(SUM(Table[Removed]), SUM(Table[Assigned]))

Regards,

Pat

[Anonymous]

if I have multiple Months/Years in the database, how do I get to tell me the Turnover by Month? 

[amitchandak]

@Anonymous , if you plot the suggested measure by month year, you will get turnover by month year