Solved: Re: Occupacy rate DAX Function

SofiaVaz · ‎07-29-2020

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 me with a dax function to do so?

Thanks in advance

Categoria

Vessel

Origem

Next Port

Destino

Voy

VoyVesYr

Date

Week

Week days

ETA

ATA

ETD

ATD

On Board

Vessel Capacity

Value

PAX

V1

SV

SA

101

101San20

19/02/2020

8

17/02/2020 - 23/02/2020

20:30:00

21:20:00

11:00:00

11:15:00

72

427

72

PAX

V1

SV

SA

103

103San20

19/02/2020

8

17/02/2020 - 23/02/2020

14:00:00

13:30:00

15:00:00

15:08:00

171

427

131

PAX

V1

SV

SA

SN

103

105San20

19/02/2020

8

17/02/2020 - 23/02/2020

14:00:00

13:30:00

15:00:00

15:08:00

171

427

40

PAX

V1

SV

SA

105

107San20

20/02/2020

8

17/02/2020 - 23/02/2020

18:00:00

17:40:00

07:00:00

07:10:00

177

427

177

PAX

V1

SV

SA

107

109San20

20/02/2020

8

17/02/2020 - 23/02/2020

10:00:00

09:35:00

11:00:00

11:50:00

147

427

147

PAX

V1

SV

SA

109

111San20

20/02/2020

8

17/02/2020 - 23/02/2020

14:00:00

13:50:00

15:00:00

15:15:00

106

427

106

PAX

V1

SV

SA

111

117San20

21/02/2020

9

17/02/2020 - 23/02/2020

18:00:00

17:35:00

07:00:00

08:05:00

159

427

159

PAX

V1

SV

SA

117

6Pra20

26/02/2020

1

24/02/2020 - 01/03/2020

19:00:00

20:23:00

16:00:00

16:05:00

357

208

357

Tahreem24 · ‎07-29-2020

(@SofiaVaz ,

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

Make sure both these columns are of numeric field.

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

View solution in original post

Mariusz · ‎07-29-2020

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

View solution in original post

Mariusz · ‎07-29-2020

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

amitchandak · ‎07-29-2020

@SofiaVaz , Try a new measure

New measure = divide(Sum('Table'[Onboard]),Sum('Table'[VesselCapacity]))

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here