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!
PaulDBrown's avatar
PaulDBrown
Community Champion
5 years ago

Anonymous 

Can you please provide a sample dataset or, even better, a sample PBIX file?

Can you please also clarify the calculations you wish to see for blue and orange highlights?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hey PaulDBrown,

    thanks for your answer.

    I cannot prvide the pbix, but some addition information you requested. Thats the table where the data comes from.

     

     

    It a simple fact table. Each column which ends with SK, hat a relation to a dimension table. The column Oee and GoodPartAmount are used for calculations.

    Blue = Sum of all OEE values per Machine and Shift

    Orange = Average of all blue cells for that specific machine and all shifts per machine.

    Regards

    Michael