I need help dividing two sums from two different tables..

[mehlenbae2]

I have two tables:

Asset

Technician

I need to divide the total of Desktop, Laptop, and Phones by the number of technicians at each site. This is what my PBI looks like:

How can I do this??

[v-xiaotang · Accepted solution]

Hi @mehlenbae2 

Thanks for reaching out to us.

>>  to divide the total of Desktop, Laptop, and Phones by the number of technicians at each site.

please try this measure

Measure = 
var _value=SUM(Asset[value])
var _total_Site=COUNTX(FILTER(Technician,Technician[site]=MIN(Asset[site code])),[site])
return DIVIDE(_value,_total_Site)

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.