Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

calculate in the table matrix

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

 

rockdotnet_0-1670825700436.png

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

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

rockdotnet_0-1670916562138.png

 

Anonymous
Not applicable

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

v-jialluo-msft
Community Support
Community Support

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

vjialluomsft_0-1670911460649.png

 

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
Not applicable

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
  )
 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.