Forum Discussion

PiyushBQ's avatar
PiyushBQ
Icon for Helper I rankHelper I
6 years ago
Solved

Show Peer Group

Hi Guys,   I have a list of two columns.   Category SKU Fruit Apple Fruit Pineapple Fruit Strawberry Vegetable Carrot Vegetable Brinjal Vegetable Cauliflower   ...
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Perhaps:

 

Measure = 
    VAR __SKU = SELECTEDVALUE('Table'[SKU])
    VAR __Category = MAX('Table'[Category])
    VAR __Table = FILTER(ALL('Table'),'Table'[Category] = __Category)
RETURN
    CONCATENATEX(__Table,[SKU],",")

PBIX attached. 

PiyushBQ's avatar
PiyushBQ
Icon for Helper I rankHelper I
6 years ago
Greg_Deckler I added Unichar(10) to achieve the desired result but all it's doing is vertically stacking the string, rather than placing string values in separate rows.
 
Measure =
VAR __SKU = SELECTEDVALUE('Table'[SKU])
VAR __Category = MAX('Table'[Category])
VAR __Table = FILTER(ALL('Table'),'Table'[Category] = __Category)
RETURN
CONCATENATEX(__Table,[SKU],UNICHAR(10))