Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |