topic Re: Slicer single selection and displaying two options in DAX Commands and Tips

Slicer single selection and displaying two options

dax_rach — Thu, 09 Feb 2023 17:32:11 GMT

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.

Re: Slicer single selection and displaying two options

tamerj1 — Thu, 09 Feb 2023 17:57:50 GMT

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 )

)

Re: Slicer single selection and displaying two options

dax_rach — Fri, 10 Feb 2023 14:23:50 GMT

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