Forum Discussion
GQ00
Helper III
8 months agomatrix visual with calculation group
I know this has been asked many times, but I am still not sure if it is possible. After I got approval from the senior team, I was able to redesign the semantic model, the data warehouse, and the re...
danextian
Super User
8 months agoHi GQ00
This is a limitation of the matrix visual itself. The upper hierarchy levels act as column headers because they come from dimensions, and in a matrix, measures are always placed at the lowest level of the hierarchy.
A workaround is to materialize the measure results into a physical column using a disconnected table. You can reuse the field parameter table as that disconnected table, but it won’t behave as originally intended — it will mainly act as a placeholder for the measure values rather than a true parameter.
Please see the attached pbix.