Divide function using two fields from different tables including filters

[Anonymous]

Hi,

I've successfully joined two tables and have included them into a matrix.

I'm now trying to divide one by the other to give a turnover rate.

But I am not getting my desired result. I want it to be drillable on all fields in my matrix.

FTE Turnover = CALCULATE(DIVIDE([Leaver FTE],[Staff FTE],0),ALL('Staff Summary'))

Can anyone please help?

If you need anymore info please let me know.

Thanks

[Anonymous]

This is the table

[v-danhe-msft]

Hi @Anonymous ,

Could you please post some simple sample data and your desired result to have a test if possible? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Regards,

Daniel He