I want to compare data with a Hierarchy that only exist on one part of the data

[JosFry]

Hello all,

I hope some one can help me with my problem.

I use two values BGR € and Voorspelling €. The voorspelling € hierarchy in on a deeper level than the BGR €.
The voorspelling € has three levels:

- kostenplaats

- F code

- employee number

The BGR € had two levels:
- kostenplaats

- F code

I know when I drill to the employee number, that the BGR € value of the F-code will show per employee-code.

My question is: When I drill down to the employee number, it is possible to only show the Voorspelling € on the employee-codes and BGR € on the F503 level as a total. Like this:

Thank you all for ready and trying to help!

Your sincerely,

Jos 

[tamerj1 · Accepted solution]

Hi @JosFry 
Let's assume [BGR €] measure is a simple of sum of a column then you can write it this way

BGR € =
IF (
    NOT ISINSCOPE ( TableName[Employee Number] ),
    SUM ( TableName[ColumnName] )
)

[JosFry]

@tamerj1 Thanks you sir!