Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
105 | |
88 | |
73 | |
66 |
User | Count |
---|---|
122 | |
112 | |
98 | |
79 | |
72 |