topic Re: I want to compare data with a Hierarchy that only exist on one part of the data in DAX Commands and Tips

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

JosFry — Tue, 30 Aug 2022 10:30:08 GMT

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

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

tamerj1 — Tue, 30 Aug 2022 10:53:00 GMT

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] ) )

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

JosFry — Tue, 30 Aug 2022 11:03:55 GMT

tamerj1 Thanks you sir!