User Profile
KGillett
Frequent Visitor
Joined 3 years ago
User Widgets
Contributions
Add a new row to Matrix based on values from other rows
Hi, I've spent more time than I'd like to admit trying to work this out myself, but I've run out of ideas. I suspect this isn't that difficult, if you know where to look. Appreciate any guidance. I have managed to create a series of unions (in DAX) that summarise information and populate nicely into a Matrix. The visual's data looks like this (with the names hidden by the green blobs): This is what I'm trying a achieve: I'm trying to add the highlighted rows to the Matrix by simply doing a calulation of 'Availability' minus 'Bookings' for each Person. I'll call this 'Balance' and show it at the bottom of each Person's records. I have been trying to add another union to do the calculation, but I can't get that to work. Guidance appreciated!
