ISINSCOPE hierarchy level

[Chris_23]

Hi,

I would like to create a Matrix / Measure, which gives me information about Due Date and Payment terms only on the lowest level of the hierarchy (Debitor --> Project --> Document No_).

The following table:

I have tried to get the desired structure via isinscope.

However, I do not manage to get the corresponding value.
The goal would be to generate the following matrix:

Due Date_M = SWITCH(

True(); ISINSCOPE(Tabelle1[Document No_]);"=Due Date";

blank())

Any suggestions?

Kind regards

[Mariusz · Accepted solution]

Hi @Chris_23 

Try this 

Due Date_M = 
IF(
    ISINSCOPE( Tabelle1[Document No_] );
    SELECTEDVALUE( Tabelle1[Due Date] )
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn