Show only common values from groups

[Anonymous]

Hi Everyone,

     I  need to show only the common vales in groups. PFB image for the same.

  Here For the S.No 1 , I have 2 groups, one is GL_JRNL & Other is GL_POST, There are 2 users are common between these 2 groups. So i need to create a measure/column to show only the common vales which are highlighted in the screenshot.

   Thanks in Advance.

[lbendlin]

What have you tried?  Seems like a combination of INTERSECT and CONCATENATEX should do the trick.

[Anonymous]

@lbendlin  Could you please show me how its done. I have no idea how its done.

[lbendlin]

Please provide sample data in usable format (not as a picture) .

[Anonymous]

Can u send me ur mail id , i will send the pbix file. Unable to send it here as I dont have the option here

[lbendlin]

click the table icon then specify the table size and fill it with your sampe data.

[Anonymous]

Link to the pbix 

Kindly check the page 1 of the file.

[Anonymous]

I am not getting how to write the expression!

[Anonymous]

Can someone help on this please!