Forum Discussion
Helper IIDivide numbers in two different tables?
I have two Tables:
Technicians
Assets
Both tables have a "Site Code" column. I need to create a measure divides the total number of technicians at a specific site code and divides it by the total number of assets at a site code.
I made two matrix:
Technician Table
| Site Code | Count of Technicians |
| LA | 4 |
| NY | 2 |
| KY | 1 |
Asset Table
| Site Code | Count of Assets |
| LA | 80 |
| NY | 75 |
| KY | 45 |
How do I create a measure that will look at the amount of technicians at a specific site and divide it by the Count of Assets at each site?
Hi, mehlenbae2
You need create a relationship between 'Technician Table' and 'Asset Table' based on field 'Site Code'.
Then add a measure like:
Result=COUNT('Technician Table'[Technicians])/COUNT('Asset Table'[Assets])Best Regards,
Community Support Team _ Eason
1 Reply
- v-easonf-msft
Community Support
Hi, mehlenbae2
You need create a relationship between 'Technician Table' and 'Asset Table' based on field 'Site Code'.
Then add a measure like:
Result=COUNT('Technician Table'[Technicians])/COUNT('Asset Table'[Assets])Best Regards,
Community Support Team _ Eason