Forum Discussion
Slicer single selection and displaying two options
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.
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 )
)
2 Replies
- tamerj1
Community Champion
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 )
)
