Slicer single selection and displaying two options

[dax_rach]

Hi everyone. Came back just a few days later with a new issue, I am very new to DAX and new issues jsut keep showing up xD

I want to know if it is possible to have a slicer that when I make a single selection, I visualize two value categories, or have a fixed value on every visual and just add the slicer selection. The reason behind this is because I always need to compare "client" against any other competitor (the one I need to select from the slicer).

Thanks again for any help I can get on this.

[tamerj1 · Accepted solution]

Hi @dax_rach 

Create a single column disconnected table that contains all the categories except "client". This table will be used as a slicer as well as in dax

a column1 sum measure would be

VAR T = UNION ( VALUES ( 'SlicerCategory'[Category] ), { "Client" } )

RETURN

CALCULATE (

SUM ( 'Table'[Column1] ),

KEEPFILTERS ( 'Table'[Category] IN T ) 

)

[dax_rach]

Hi @tamerj1 . Thank you very much for your help. I tested it out this morning and it helped me a lot!