cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

4 REPLIES 4
Anonymous
Not applicable

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

Anonymous
Not applicable

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

Community Support

Hi  @Anonymous ,

(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
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
)

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

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

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors