Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Tricky Slicer Options

I have a Fact table in SSAS Tabular model which contains column name "Flag" with only possible values Yes or No,

 

I have to create a slicer Control with Yes or No, If user clicks Yes then it should filter Only Yes records but if User Clicks in No It should display all records without applying any Filter. So can you help me how to achieve this.

Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Anonymous,

     

    Add a separate table for Slicer, drag measure below to Visual level filters and set Show items when the value is 1.

    Table =
DISTINCT ( 'Fact'[Flag] )

    Measure =
IF (
    SELECTEDVALUE ( 'Table'[Flag] ) = "Yes"
        && SELECTEDVALUE ( 'Fact'[Flag] ) = "No",
    0,
    1
)

4 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    7 years ago

    Anonymous,

     

    Add a separate table for Slicer, drag measure below to Visual level filters and set Show items when the value is 1.

    Table =
DISTINCT ( 'Fact'[Flag] )

    Measure =
IF (
    SELECTEDVALUE ( 'Table'[Flag] ) = "Yes"
        && SELECTEDVALUE ( 'Fact'[Flag] ) = "No",
    0,
    1
)
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      It is not working, Can you please share sample PBIX file.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hello v-chuncz-msft , Can you please help me with sample PBIX file, the below expression not working.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        I have delete the relation between them and it automaticall working thank you for the solution.