So, I have a DAX model and I want to build a report from it. The column structure of the report is OutputDescription, Fact 1, Fact 2, Fact 3.
I want to add different fields from my dimensions into the OutputDescription field. For example, I want to see Total Beer and the associated facts but in the same column (OutputDescription) I also want to add Total Smirnoff and the associated facts, both of which come from different levels in the model. Total Beer comes from my category dimension, whereas smirnoff comes from my brand family dimension.
How would you recommend that I approach this? Ideally, I'd like to do as much work as possible in my model to ensure that the report is not burdened with lots of filters and such.