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...
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

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