Forum Discussion

ManOAction's avatar
ManOAction
New Member
8 years ago
Solved

Calculated Row in Matrix

I'm brand new to Power BI and I'm having a hard time figuring this out.   I'm building a financial report, and I'd like to include a calculated row (not a column).  The data is expense_type (rows) ...
  • ManOAction's avatar
    ManOAction
    8 years ago

    That makes sense.   

     

    I've written it into the underlying query in data warehouse as a union select, and it's working fine.

     

    Thanks so much for your help.

ManOAction's avatar
ManOAction
New Member
8 years ago

Thanks, that's helpful feedback, but not quite what I need.

 

It's now repeatedly showing it as a subset of all rows.  I need it to show only once.  The same that a subtotal would work.

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

This can be done in Excel by converting the PowerPivot table into cube formulas.