Forum Discussion

Lily_DS's avatar
Lily_DS
Frequent Visitor
3 years ago
Solved

column value based filter

hello    I am building a dashboard contains a filter of companies name i need please hide the other names depends on this filter for example:   table look like: name amount aramco 2001...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, Lily_DS 

     

    You can try the following methods.
    Measure:

    Name measure = 
SWITCH(TRUE(),
    SELECTEDVALUE ( Slicer[name] ) = BLANK (),SELECTEDVALUE ( 'Table'[name] ),
    SELECTEDVALUE ( Slicer[name] ) = SELECTEDVALUE ( 'Table'[name] ),SELECTEDVALUE ( 'Table'[name] ),
    "-"
    )

    Is this the result you expect?

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, Lily_DS 

 

You can try the following methods.
Measure:

Name measure = 
SWITCH(TRUE(),
    SELECTEDVALUE ( Slicer[name] ) = BLANK (),SELECTEDVALUE ( 'Table'[name] ),
    SELECTEDVALUE ( Slicer[name] ) = SELECTEDVALUE ( 'Table'[name] ),SELECTEDVALUE ( 'Table'[name] ),
    "-"
    )

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Lily_DS's avatar
Lily_DS
Frequent Visitor
3 years ago

thank you so much ,,  I tryed your solution it's great.🙏