Profit and Loss Statement Totals

[KnowNow]

Hi,

Please help with my profit and loss statement. My report source is an sql directly from the database. The accounts table already has the headers assigned to the accounts. However, I am not able to make the totals to show up correctly. The Power BI "total" needs to go away. The totals for each category show below should be the only line items shown according to the requirements. I have attached a file with sample data to show how my data model and the way the accounts are mapped from the source.

I don't see how to attach the file but a snippet of what it currently looks like is below.

[parry2k]

@KnowNow your original question was not to show the total line and that was the reason for the answer, Not fully sure what your actual requirement is.

[Anonymous]

Hi @KnowNow ,

as @parry2k  mentioned, your original requirement is about removing the grand total of matrix, but youe current descriotion is that your total is not right, can you provide some sample data and the corrcet output you want?

Best Regards!

Yolo Zhu

[parry2k]

@KnowNow you can turn off the total in the format pane. 

[KnowNow]

I understand that I can turn off the totals. I tried that but then my Net Income amount is not correct. I have created a measure for the net income that calculates correct but how do I get Power BI to show the calculated measure and not the running total from my source data. There are additional categories that contributes to the Net Income total.