calculate in the table matrix

[Anonymous]

I'm newbie with the matrix.  Need help to calculate in the matrix table and i will ad

[Anonymous]

my only problem is the total now.  I want the total to be in the average total 

[Anonymous · Accepted solution]

i solved it already, i changed the sumx() to averagex()

[v-jialluo-msft]

Hi  @Anonymous ,

Please follow these steps:
(1) Create a new column measure

Divide = DIVIDE((MAX('Table'[Visit])*MAX('Table'[Ave.LOS])),(MAX('Table'[Bed Count])/MAX('Table'[Day/Month])),0)

(2)Final output

Best Regards,
Gallen Luo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I used this measure and is working perfectly

Occupancy Rate =

SUMX('OSR-LOS All',        

        ((('OSR-LOS All'[IPD_Visit] * 'OSR-LOS All'[AverageLOS]) / ('OSR-LOS All'[BedCount] * 'DAX Table'[LOS Days/Month])) * 100) / 100

  )