3 Different slicers as one slicer with dropdown

[harshagraj]

Hello all i have made 3 calculated columns with dax as Opt.1, Opt.2 & Opt.3

Opt.1 = if column A=1 or Column B=1 ,"Option1" , Blank
Opt.2 = if column C=1 or Column D=1 ,"Option2" , Blank
Opt.3 = if Opt.1="Option1" OR Opt.2 = "Option2", "Option3", Blank

Now i need to get Opt.1,Opt.2 & Opt.3 as a single slicer instead of 3 different slicers.
I need to make this in dax and not on Power Query.

Opt. 1	Opt. 2	Opt. 3
Option 1	Option 2	Option 3
Option 1	Option 2	Option 3
Option 1	Option 2	Option 3
Option 1		Option 3
Option 1		Option 3
Option 1	Option 2	Option 3
Option 1		Option 3
Option 1		Option 3
Option 1		Option 3
Option 1		Option 3

Thanks in advance
@amitchandak please help.

[amitchandak]

@harshagraj ,depend on how you want to utilize it . You can have a new tbale

Distinct(Union(Distinct(Table[Opt 1]),Distinct(Table[Opt 3]),Distinct(Table[Opt 3]) ))

Join with all three columns, two join will be inactive, That you can activate in the measure using use relationship

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...