Forum Discussion

Rednut's avatar
Rednut
Regular Visitor
4 years ago
Solved

Distinct/union/selectcolumns on more than 2 columns

I'm trying to create a new table that will be used for a slicer.

I can manage to create it when theres 2 columns but not 3 or more.

i have column a and b with different values and then a 3rd column that is concatenation of a and b as below. but when i try to do it with 3 columns it returns an error.

 
Project Location Slicer = DISTINCT(
Union (
SELECTCOLUMNS ('Dashboard Data (2)',
"Project Location", 'Dashboard Data (2)'[Project Location (a)],
"Concatenate", 'Dashboard Data (2)'[Project Location]),
(
SELECTCOLUMNS('Dashboard Data (2)',
"Project Location", 'Dashboard Data (2)'[Project Location 2 (b)],
"Concatenate", 'Dashboard Data (2)'[Project Location]
))))
 
how can i add more SELECTCOLUMNS to this table? something like this below
 
Project Location Slicer = DISTINCT(
Union (
SELECTCOLUMNS ('Dashboard Data (2)',
"Project Location", 'Dashboard Data (2)'[Project Location (a)],
"Concatenate", 'Dashboard Data (2)'[Project Location]),
(
SELECTCOLUMNS('Dashboard Data (2)',
"Project Location", 'Dashboard Data (2)'[Project Location 2 (b)],
"Concatenate", 'Dashboard Data (2)'[Project Location],
(
SELECTCOLUMNS('Dashboard Data (2)',
"Project Location", 'Dashboard Data (2)'[Project Location 2 (c)],
"Concatenate", 'Dashboard Data (2)'[Project Location]
))))
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Rednut , Some issue with parenthesis

     

    Project Location Slicer = DISTINCT(
    Union (
    SELECTCOLUMNS ('Dashboard Data (2)',
    "Project Location", 'Dashboard Data (2)'[Project Location (a)],
    "Concatenate", 'Dashboard Data (2)'[Project Location]),
    SELECTCOLUMNS('Dashboard Data (2)',
    "Project Location", 'Dashboard Data (2)'[Project Location 2 (b)],
    "Concatenate", 'Dashboard Data (2)'[Project Location])
    SELECTCOLUMNS('Dashboard Data (2)',
    "Project Location", 'Dashboard Data (2)'[Project Location 2 (c)],
    "Concatenate", 'Dashboard Data (2)'[Project Location]
    ))

     

     

    use summarize in place of the select column if it gives circular dependency error with joins

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Rednut , Some issue with parenthesis

     

    Project Location Slicer = DISTINCT(
    Union (
    SELECTCOLUMNS ('Dashboard Data (2)',
    "Project Location", 'Dashboard Data (2)'[Project Location (a)],
    "Concatenate", 'Dashboard Data (2)'[Project Location]),
    SELECTCOLUMNS('Dashboard Data (2)',
    "Project Location", 'Dashboard Data (2)'[Project Location 2 (b)],
    "Concatenate", 'Dashboard Data (2)'[Project Location])
    SELECTCOLUMNS('Dashboard Data (2)',
    "Project Location", 'Dashboard Data (2)'[Project Location 2 (c)],
    "Concatenate", 'Dashboard Data (2)'[Project Location]
    ))

     

     

    use summarize in place of the select column if it gives circular dependency error with joins