Forum Discussion

Ruan-BFI's avatar
Ruan-BFI
Frequent Visitor
6 years ago

Measure unaffected by Dimensions

Hi Power BI Community

 

I am trying to build a Profit & Loss and Balancesheet inside Power BI. I have my fact table with all my transactions and a dimension table with the account names.

 

I have a visual issue with the Balance sheet. I am trying to display the total Nett/Profit loss from the Profit & Loss table as 1 row in my Balance sheet, but becuase I use the Account names from my DimTable as rows in my Matrix visual it shows the different Profit & Loss accounts as well.

 

Here is example:

 

As you can see this includes P&L accounts and also Equity accounts like Retained earnings. I want to group all P&L accounts, but still show the balance sheet accounts as seperate rows.

 

 

 

 
 

Thanks in advance for the help.