Forum Discussion

anonymoususer92's avatar
anonymoususer92
Icon for Helper I rankHelper I
4 years ago
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...
Need Help
Show and Tell
  • johnt75's avatar
    johnt75
    4 years ago

    You could try creating a measure like

    Utilization = DIVIDE( COUNTROWS( 'Badging Table'), SELECTEDVALUE( 'Occupancy Table'[Assigned Spaces]) )
johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

You could try creating a measure like

Utilization = DIVIDE( COUNTROWS( 'Badging Table'), SELECTEDVALUE( 'Occupancy Table'[Assigned Spaces]) )