Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Occupacy rate DAX Function

Hi all,    please see bellow a sample of my db.   I'm trying to find a measure to calculate de occupation rate per vessel and voyage. It would be = On board / vessel capacity.    Can you help m...
Need Help
  • Tahreem24's avatar
    Tahreem24
    6 years ago

    (Anonymous ,

    Occupancy Rate = Sum(Table[Onboard])/Sum(Table[VesselCapacity])

    Make sure both these columns are of numeric field.

     

  • Mariusz's avatar
    Mariusz
    6 years ago

    Hello @SofiaVaz

    Try this Measurement.

    Measure = 
DIVIDE(
    SUM( 'Table'[On Board] ),
    SUM( 'Table'[Vessel Capacity] )
)

    Best regards
    Mariusz

    If this post helps,then consider accepting it as the solution.

    Please feel free to connect with me.
    Linkedin


Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hello @SofiaVaz

Try this Measurement.

Measure = 
DIVIDE(
    SUM( 'Table'[On Board] ),
    SUM( 'Table'[Vessel Capacity] )
)

Best regards
Mariusz

If this post helps,then consider accepting it as the solution.

Please feel free to connect with me.
Linkedin