Forum Discussion

BSM1985's avatar
BSM1985
Helper IV
4 years ago

Custom table slicer

Hi Team,   I want to filter the existing table based on selection in the slicer which is populated thru custom table.   Step 1:  I created a custom table using DAX with below values Color Green...
Need Help
v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi BSM1985 ,

 

Does the custom table have relationship with fact table?

if no , try this measure 

m =
VAR _s =
    SELECTEDVALUE( 'custome table'[color] )
RETURN
    IF( _s = "ALL Colors", 1, IF( 'fact table'[color] = _s, 1, BLANK() ) )

 

then put the measure in the filters on the visual with you want to apply and set item is 1

Best Regards

Community Support Team _ chenwu zhu

 

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