The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I'm newbie with the matrix. Need help to calculate in the matrix table and i will ad
Solved! Go to Solution.
i solved it already, i changed the sumx() to averagex()
my only problem is the total now. I want the total to be in the average total
i solved it already, i changed the sumx() to averagex()
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.