Forum Discussion
Unique Slicer values from several columns
Anonymous , One way it unpivot the column in Power Query and get them in one column.
Another way is to create a table in DAX
Table = Distinct(Union(Distinct(Table[Col1]),Distinct(Table[Col2]),Distinct(Table[Col3]),Distinct(Table[Col4]),Distinct(Table[Col5]) ) )
You can join it with all columns back and can use userelationship to create measures
Super UserAnonymous , One way it unpivot the column in Power Query and get them in one column.
Another way is to create a table in DAX
Table = Distinct(Union(Distinct(Table[Col1]),Distinct(Table[Col2]),Distinct(Table[Col3]),Distinct(Table[Col4]),Distinct(Table[Col5]) ) )
You can join it with all columns back and can use userelationship to create measures
Thanks! That DAX formula is exactly what I needed.
I am however not too good with creating relationships, how would I go about writing those DAX expressions measures for text values?
Also I can only create many to many relationships for some reason: