Forum Discussion
adding measures as columns to a matrix
Hi All, So I have a matrix table shown below and I wanted to include 3 measures that I have created (overall average per ward, Target and % ratio which is overall avg divided by target). I want thi...
PaulDBrown
Community Champion
Community ChampionSee if this helps:
PaulDBrown Thank you for your reply. I was hoping there was a measure that I could use to ensure that the aggregate values (average, target, %) appear as columns. The dataset I am working with doesn't permit the creation of new tables or columns whilst working with the certified dataset so was hoping I could use a measure to give me the layout below;
Preferred Matrix table layout
- PaulDBrown
Can't you import new tables? You cannot create new tables using DAX either?