Forum Discussion
Release filter by drill down level
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)
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.
1 Reply
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.