Sorry, I didn't fully explain my situation. I have dozens of clients and every client has those 5 rows with a client ID. Your solution, while elegant, it will only work if there was only one set if clients.
I ended up splitting the table into 5 smaller tables each containing one category and then doing calculations that way. I know it's not clean.
It seems you may use "Append Queries" in query editor to combine the tables. Then you may use the measure as HarrisonCbe mentioned. If it is not your case, please share sample data for your scenario so that we could help further on it.
Community Support Team _ Cherie Chen If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.