Forum Discussion

powerBIpeon's avatar
powerBIpeon
Helper II
7 years ago
Solved

Not Selected Values

similart to this thread, however i want to know if there is a way to have these customers grouped https://community.powerbi.com/t5/Desktop/Not-Selected-Values/m-p/572530#M270416   Table1 has Colum...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi powerBIpeon

     

    You may try below measure:

    Measure =
CONCATENATEX (
    FILTER (
        Table2,
        Table2[Group] = MAX ( Table2[Group] )
            && NOT ( Table2[Cust] ) IN VALUES ( Table1[Cust] )
    ),
    Table2[Cust],
    ","
)

    Regards,

    Cherie

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi powerBIpeon

 

You may try below measure:

Measure =
CONCATENATEX (
    FILTER (
        Table2,
        Table2[Group] = MAX ( Table2[Group] )
            && NOT ( Table2[Cust] ) IN VALUES ( Table1[Cust] )
    ),
    Table2[Cust],
    ","
)

Regards,

Cherie

powerBIpeon's avatar
powerBIpeon
Helper II
7 years ago

Thank you both for the help!