Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Value not at lowest level

Hello,   I have a hierarchy with five levels. Four levels are in one table, and one table is connected with one hierarchy level (*-1). The cross filter direction is both sides. How can i get the va...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi Anonymous 

     

    Can you share some dummy data to describe the input data and output result more clearly? Which 4 levels are in one table and which columns are the two tables connected to each other?

     

    You may use a condition like 

    ISINSCOPE ( 'table'[level 1] ) && NOT ( ISINSCOPE ( 'table'[level 5] ) )

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous 

 

Can you share some dummy data to describe the input data and output result more clearly? Which 4 levels are in one table and which columns are the two tables connected to each other?

 

You may use a condition like 

ISINSCOPE ( 'table'[level 1] ) && NOT ( ISINSCOPE ( 'table'[level 5] ) )

 

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.