Ignoring filter context / summing items from different filter contexts

[Aikarauta]

Hey there,

I am having trouble visualizing Balance Sheet. In my report I have two separate matrix tables for visualizing Current Assets and Current Liabilities.

The problem that I am facing is that Current Assets equals to Current Liabilities only on the last day of Financial Year as cumulative Win/Loss is only calculated once per financial year in my dataset (on the very last day, when the balance of the Income Statement is actually transferred to Balance Sheet account). Given that I can get the daily Win/Loss with this formula:

WinOrLoss = CALCULATE(SUM(Invoked Function[DEBET-KREDIT]), AccountMapping[LEVEL]="Income Statement")

When visualizing Balance sheet I have filtered my matrix to show only items that belong to Balance Sheet. I can get Current Liabilities equal to Current Assets if I add daily WinOrLoss to Current Liabilities. Since my matrix table is set to visualize only items that belong to Balance sheet, Current Assets will not equal to Current Liabilities if don't remove this filter context. 

Here's the formula that I use to get the daily balance of Balance Sheet:

Balance Sheet = CALCULATE((SUM(DEBET-KREDIT) + [OPENING BALANCES]), AccountMapping[LEVEL]="Balance Sheet")

 In other words, I need a way to sum WinOrLoss to Current Liabilities without including Income Statement items in the matrix visualization. Any other convenient way will also do!

Thanks!

[VijayP]

@Aikarauta 

With above explanation you have created the Dax as required. But still why you are not able to get the result.

CAn you paste a sample picture or share a smaple data to resolve it?

Regards

Vijay Perepa

[Aikarauta]

@VijayP 

It will get me the desired result if I remove the filter context from the matrix from "only show items that belong to Current Liabilities" to "show items that belong to current liabilities and Income Statement". After that it will also map out all the accounts that belong to the Income Statement to the matrix and that's something I would not like do. 

With these calculations the filter contexts collide if I simply add em up and therefore will not give me the correct result.

I can post you sample picture later on if this doesn't help you.

[VijayP]

@Aikarauta 

If I understood correctly you are using Internal Filters using Filters PANE , what i Suggest use Slicers (external filters) to get your desired result