Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Checking if element belongs in same groups as a selected one.

I have a dashboard showing different data about different events. The selection of a specific event to investigate is done on a slicer showing a "short description" for each event. In a table CUR...
Need Help
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
2 years ago

Anonymous 

pls see if this is what you want

Do not create relathionship between two tables.

 

create measures

 

Measure =
 VAR _group=distinct('Table'[Group Num])
 var tbl=FILTER(all('Table'),'Table'[Group Num] in _group)
 return CONCATENATEX(tbl, [Event Name],",")
 
Measure =
 VAR _group=distinct('Table'[Group Num])
 var tbl=FILTER(all('Table'),'Table'[Group Num] in _group)
 return CONCATENATEX(tbl, [Event Name],",")
 
and add the measure 2 to visual filter and set to 1
 
 
pls see the attachment below
 
 
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    It is not working for me.
    The difference being that I need to have the slicer set to use a "description" field in your "Table (2)".
    When I change your file in that respect I get the same behavior, with the Table visual returning only the selected value.

    • ryan_mayu's avatar
      ryan_mayu
      Icon for Super User rankSuper User
      2 years ago

      then could you pls update your sample data and elaborate more about the expected output?

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        I edited the post, making it very general but explaining better the problem I have.
        Thanks for bearing with me!