Forum Discussion
Solved
Dividing a Measure by a Column
Hi All, Here is my situation - We are trying to calculate our building utilization by comparing how many people are returning to work and what was the original building assignment of these empl...
You could try creating a measure like
Utilization = DIVIDE( COUNTROWS( 'Badging Table'), SELECTEDVALUE( 'Occupancy Table'[Assigned Spaces]) )
You could try creating a measure like
Utilization = DIVIDE( COUNTROWS( 'Badging Table'), SELECTEDVALUE( 'Occupancy Table'[Assigned Spaces]) )Thank you so much johnt75 ! This works perfectly
