Measure outside column hierarchy in Matrix visual

Hi mwegener,

First of all, Kudos for the solution that was beyond expection!!

However, I noticed that you have intentionally kept a blank row in your location table, which shows up under the two separate header ('Current WAC' & 'Total Value') and solves the purpose in your case. However, in my case it is not the case as it is a predefined dataset from a client and I cannot intsert a blank row in that and Hence, not able to replicate the solution. If you can help a bit with that as well, it would be great!!

I have still marked as a solution because it is almost the solution that I was looking for. Cheers!

Excellent Solution, to add data at the end or outside the hierarchy of columns in the visual matrix, this solution has worked perfectly for me.
This approach is laborious to implement and the complexity of each particular case.
It cost me a lot of time and work but in the end it was worth the effort.

The following image shows the result obtained and that is exactly what I had designed in SSRS.

If it is a lot of effort, especially when it is the first time, for the second or third report the design time in the part of the data model and in the DAX coding is reduced.

I hope that in the future this will be implemented and integrated in some way in some visualization.

Thank you very much for your input mwegener , Regards

Please can you re-upload this PBIX file? This is the only solution I've been able to find.

Thanks.