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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.