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

    Thank you for taking the time out, Greg.

    This works!

    Can you please guide on structuring the layout?

    An output in the matrix table would be ideal. That'll allow me to display KPIs for the rivals

    Example:

    ItemKPI 1KPI 2
    StrawberryValueValue
    PineappleValueValue
    AppleValueValue


    Again, thanks heaps!

  • 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))