Forum Discussion
Solved
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 sin...
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 )
)
tamerj1
Community Champion
Community ChampionHi 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 )
)
