adding measures as columns to a matrix

[Medolah]

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 this 3 columns at the end of matrix, however Power BI keeps displaying the aggregate figures of the 3 measures for each week instead of a combined total for all 3 weeks. I have included a dummy pbix file that contains 2 pages; the matrix table and another page with the 3 measures I am trying to include at the end of the matrix table page. The dax I used to to create the average is also listed below and is contained in the pbix file (see link below) attached within. Can anyone help?

https://1drv.ms/u/s!AhEw68UYqcc6gwkbY0ziWLXXVheX?e=FeMUim

Average = 
AVERAGEX(
VALUES(' Calendar'[Week Ending Year]),
'Inpatients Measures'[Inpatient Discharges]
)

Matrix table

[PaulDBrown]

See if this helps:

Creating a custom matrix 

[Medolah]

@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?

[Anonymous]

Hi @Medolah ,

I open a PBIX file and it says I don't have permission to connect to the data source.

Would you mind re-providing data that has no privacy? You may consider using import mode for PBIX files. Thanks in advance.

Best Regards,
Community Support Team_Gao

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Medolah]

@Anonymous I have resent it and hope you can now open it. https://1drv.ms/u/s!AhEw68UYqcc6gwkbY0ziWLXXVheX?e=FeMUim