Release filter by drill down level

[Anonymous]

Hello,

I'm trying to show accounting data to the user with PowerBI. The user needs to see trail from the account to the journal entry.

Level 1 is the Accounts and their sum.

Level 2 is the drill down to account, showing all entries to the account.

Level 3 is the drill down showing the all the rows of the journal entry.

Problem is that with drill down, each level adds to the filter and I would need to release the filter for the highest level when the user is at the lowest level(Level 3).

Level 1		Level 2		Level 3
Overview		Account 1030	Journal Entry 1
Account	Sum	Journal Entry	Sum	Account	Journal Entry	Sum
1030	4000	1	200	1030	1	100
1040	9500	2	3000	1030	1	100
		3	800	1040	1	-100
				1040	1	-100

Level 1 Filter

Account (all)

Journal entry(all)

Level 2 Filter

Account is 1030

Jornal entry(all)

Level 3 Filter

Account (all)

Journal entry(1)

[BhaveshPatel · Accepted solution]

You should write the meaure such as this.

Measure1:=CALCULATE(SUM[AMOUNT]),ALL(Table[Accounts])

Measure2:=CALCULATE(SUM[AMOUNT]), Table[Accounts]="1030")

Measure3:=CALCULATE(SUM[AMOUNT]),ALL(Table[Journals]

And Drag and drop them around and it would solve your problem.