Column with the Wrong Values because of Missing Input

[T_JF2022]

Hello all,

my problem is that I have a data set which is structured as follows.
I have an accounting group which combines several accounts. Sales or even costs arise on each account. The budget, on the other hand, is only created on the accounting group.
If I put a matrix table over this data set, the result fits on the basis of the Accounting Group. When I look at the drilldown at the account level, it takes the value that was formed for the account group because it has no values.
Without adjusting the budget data set and adding empty values for individual accounts, can I make it so that the drilldown does not contain incorrect values? See the Screenshot

I've addet a Test Dataset:

Test Data - Google Drive 

Thanks for your help

KR JF

[johnt75]

You can use ISINSCOPE , e.g.

Amount at group grain =
IF ( NOT ISINSCOPE ( 'Table'[Account ID] ), SUM ( 'Table'[Amount] ) )

so that it will return blank if the report is at the account level but will return the correct value at group or total.

[T_JF2022]

With a look into my TestData, can you explain me which tables I have to choose?

[johnt75 · Accepted solution]

Amount at group grain = 
IF ( NOT ISINSCOPE ( Accounts[Account] ), SUM ( 'Budget'[Amount] ) )