Forum Discussion

Chris_23's avatar
Chris_23
Icon for Helper II rankHelper II
6 years ago
Solved

ISINSCOPE hierarchy level

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
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    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


     

1 Reply

  • Mariusz's avatar
    Mariusz
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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