The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
User | Count |
---|---|
80 | |
74 | |
41 | |
30 | |
28 |
User | Count |
---|---|
107 | |
96 | |
53 | |
47 | |
47 |