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!
Anonymous's avatar
Anonymous
Not applicable
5 years ago

mhossain 

The pbix unfortunately contains sensitive data. Is there any way to alter the data in Power BI? Otherwise, I have to alter the data in the datasource and then import it to Power BI.

Regards

Michael

PaulDBrown's avatar
PaulDBrown
Community Champion
5 years ago

Anonymous 

One way is to create dummy tables in Excel with equivalent columns (dummy names and values) and use these to replicate the model in PBI. We only need the tables you are using in the matrix (Dimension and fact tables). No need for the whole model.

the tables can be short of course: no need for thousands of rows. 
it is helpful to understand the structure, relationships, hierarchies etc. it may also be useful to check that the actual results are what you are expecting.

also probably simpler than actually altering the original data.