Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Matrix Table: Average in Row and Sum in Column Header

Hi everyone, I have a matrix table, where I calculate the average per row using a measure. But in the column header, I need to sum the average values.  Here is an example of what I would like to ac...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi Anonymous,

     

    Create a measure as below;

    Measure = IF(ISINSCOPE('Table'[Date]),'Table'[M_SUMOEE],SUMX(VALUES('Table'[Machine]),'Table'[M_SUMOEE]))

    And you will see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi Anonymous,

 

Create a measure as below;

Measure = IF(ISINSCOPE('Table'[Date]),'Table'[M_SUMOEE],SUMX(VALUES('Table'[Machine]),'Table'[M_SUMOEE]))

And you will see:

For the related .pbix file,pls see attached.

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi v-kelly-msft,

 

I'm sorry for my late reply. Thank you the provided pbix. Unfortunately the measure seems not to work as I expect. I've added an addition row to the table (see red mark below).  

 

 

That is the result in the table

Instead of 0.45 (second row, column Average), the value must be 0.9 (0.8 + 0.1). The average value in the header should be 0.74 ((0.9 + 0.78 + 0.55) / 3).

 

Thanks and regards

 

Michael