Forum Discussion

hmokkapati's avatar
hmokkapati
Helper II
9 years ago
Solved

Matrix - row total formula

Hello,   I have line items (rows) in a matrix and I would need the Total to be calculated differently for different line Items. For ex, it needs to add all monthly values for one and avg for others...
Need Help
  • hmokkapati's avatar
    hmokkapati
    9 years ago

    Bhavesh and Angelia, thanks for your response.

     

    For now, i got around the problem by getting the Yearly totals from the source itself. This is being calculated in the source data so i am able to pull it in.

     

    But surely would like to know how such requirements (P&L items) are handled in Power BI. Looks like there is better control in excel as we can manipulate (even in terms of formatting) at cell level once the pivot table is placed on the sheet.

     

    Thank you,

    Harisha

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago


hmokkapatiIn Power BI Desktop, the data field you put in Values pane will be aggregated in “Total” column. We can only specify one aggregation type. It’s not possible to specify a dynamic aggregation type for same field.

Best Regards,
Angelia

hmokkapati's avatar
hmokkapati
Helper II
9 years ago

Bhavesh and Angelia, thanks for your response.

 

For now, i got around the problem by getting the Yearly totals from the source itself. This is being calculated in the source data so i am able to pull it in.

 

But surely would like to know how such requirements (P&L items) are handled in Power BI. Looks like there is better control in excel as we can manipulate (even in terms of formatting) at cell level once the pivot table is placed on the sheet.

 

Thank you,

Harisha

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

     

     

    We have exactly the same the same requirement with different measures in each row in matrix and we need row wise total at the end column. Can we acheive it in Power BI?