Forum Discussion

LPenatti's avatar
LPenatti
Icon for Helper II rankHelper II
7 years ago
Solved

Order By using number in concatenateX

Hi everyone!   I have a chiclet slicer and a card visulization. The card shows what's selected on chiclet slicer (picture 1) To do it I used the following function as a measure: Region_select...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi LPenatti 

    Add "Name" column from "latin map" table  in the slicer, create a measure

    Measure = CONCATENATEX(ALLSELECTED('Table'),'Table'[Name],",",'Table'[Pos])

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
7 years ago

LPenattiit might work

 

Measure = 

CONCATENATEX('Table','Table'[Column1],",",RELATED(T2[Pos]))

 Sample data for the measure

Column1
Brazil
South
North
Brazil

 

Table

 

Column1Pos
North1
Brazil2
South3

T2

LPenatti's avatar
LPenatti
Icon for Helper II rankHelper II
7 years ago

Hi smpa01, thank you for your reply!

 

Let's say it almost worked, but now it's showing repeated values:

 

I said it "almost worked" because it started with North, exactly the way I want.

 

The measure:

region_select = 

//old
//VAR _Concat = CONCATENATEX(VALUES('Database'[Region]); 'Database'[Region]; ", ")

//new
VAR _Concat = CONCATENATEX('Database'; 'Database'[Region]; ", "; RELATED('Latin America Map'[Pos]))

RETURN _Concat

I tried to substitute the first argument on CONCATENATEX 'Database' by VALUES('Database'[Region]) but it doesn't work.

 

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi LPenatti 

    What final result do you want?

    If select map visual "north", the card visul should show "north",

    If select map visual "south", the card visul should show "north, brazil,south", right?

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    • LPenatti's avatar
      LPenatti
      Icon for Helper II rankHelper II
      7 years ago

      Hi v-juanli-msft , thank you for your reply.

       

      The result I need is the Card visual shows what's selected in Map Visual filter, in the following order: "North, Brazil, South" (if all regions are selected, of course).

      • v-juanli-msft's avatar
        v-juanli-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi LPenatti 

        Add "Name" column from "latin map" table  in the slicer, create a measure

        Measure = CONCATENATEX(ALLSELECTED('Table'),'Table'[Name],",",'Table'[Pos])

        Best Regards
        Maggie
        Community Support Team _ Maggie Li
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.