Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |