Filters issue with Calculated Dimension

[nvrphanikumar]

I have this calculated dimension.

Basically,when a user makes selections on MyLv16, i would like to show MyLvl6Directs values

if they selected MyLv15,Then MyLvl5Directs

I was able to confirm that,Its showing the right values from right columns.

But when a selection is made, search bar gets messed up displaying all columns in the calculated dimension.

Example,If i select values from MyLvl4Directs , It selects all the dimensions as filter selctions in the selection bar.

Am i doing something wrong here ? Any suggestions please?

=

If(GetFIELDSelections(MyLv16)>1,

     MyLvl6Directs,

If(GetFIELDSelections(MyLv15)>1,

     MyLvl5Directs,

If(GetFIELDSelections(MyLv14)>1,

     MyLvl4Directs,

If(GetFIELDSelections(MyLv13)>1,

     MyLvl3Directs,

If(GetFIELDSelections(MyLv12)>1,

     MyLvl2Directs,

     If(GetFIELDSelections(MyLvl1)>1,

         MyLvl1Directs,

         [Directs Only]

      )

)

)

)

)

)

[vunguyenq89]

Can you share a sample app to quickly demonstrate the issue?

[shraddha_g]

Try

If(GetSelectedCount(MyLv16)>1,

     MyLvl6Directs,

If(GetSelectedCount(MyLv15)>1,

     MyLvl5Directs,

If(GetSelectedCount(MyLv14)>1,

     MyLvl4Directs,

If(GetSelectedCount(MyLv13)>1,

     MyLvl3Directs,

If(GetSelectedCount(MyLv12)>1,

     MyLvl2Directs,

     If(GetSelectedCount(MyLvl1)>1,

         MyLvl1Directs,

         [Directs Only]

      )

)

)

)

)

)

[nvrphanikumar]

This has the same behavior as well.