Forum Discussion

Martin_D's avatar
Martin_D
Icon for Solution Sage rankSolution Sage
2 years ago
Solved

Sorting a single column table within a measure?

Hi, Is there a way to sort a table within a measure? The case: I have a column 'Customer'[City] (could be any text column). I want to CONCTENATEX the first five city names in the context, b...
  • aduguid's avatar
    aduguid
    2 years ago

    Give this a try 

    CONCATENATEX (
    SELECTCOLUMNS (
        TOPN (
            5,
            DISTINCT ( 'Customer'[City] ),
            'Customer'[City], ASC
        ),
        "City", 'Customer'[City]
    ),
    [City],
    ", ",
    'Customer'[City], ASC
)
aduguid's avatar
aduguid
Icon for Memorable Member rankMemorable Member
2 years ago

Give this a try 

CONCATENATEX (
    SELECTCOLUMNS (
        TOPN (
            5,
            DISTINCT ( 'Customer'[City] ),
            'Customer'[City], ASC
        ),
        "City", 'Customer'[City]
    ),
    [City],
    ", ",
    'Customer'[City], ASC
)