Forum Discussion

Medolah's avatar
Medolah
Regular Visitor
4 years ago

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

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      Medolah
      Regular Visitor
      4 years ago

      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's avatar
        PaulDBrown
        Icon for Community Champion rankCommunity Champion
        4 years ago

        Can't you import new tables? You cannot create new tables using DAX either?