Forum Discussion
Helper IISlicing Issue with Drilldown
Hi there.
Currently I have a report that is not correctly slicing my budget data by the account hierarchy level I have created. I have 3 allocations at the lowest granularity level that are all repeating the same value (the total of the budgets for February) and not slicing correctly.
When I tried to adjust the cross filter direction to a bi-directional filter (to filter from the Chart of Accounts through the Budget Accounts and then to Budgets, the figures are not adding up correctly. ie total budgets should be 192m but instead are displayed as 109m.
Any help to get the correct slicers using the below pictures would be of great help.
3 Replies
v-jiascu-msftMicrosoft Employee
Hi toddpbi,
That could be the trick of context. Can you share the sample please? At least the formula.
Best Regards,
Dale
toddpbiI am simply using a total budgets measure, derived from my Budgets table.
Total Budgets = SUM ( Budgets[Budget] )
The issue is, my budgets table is not directly connected to the Chart of Accounts and so I cannot filter the Budgets by the Chart of Accounts hierarchy I have created in my model. Essentially, I need the filter to flow down from the Chart of Accounts table to filter my budgets as well as my actuals table.
- toddpbi
For example, I have three aggregations of accounts:
Budgets Actuals
ADM FIX 1000000 3405921SCO FIX 1000000 2019475
SCO VAR 1000000 9581746
So, my actuals are being sliced correctly but my budgets are not (simply repeating the aggregated sum of the total budgets measure).