topic Re: Show only common values from groups in DAX Commands and Tips

Show only common values from groups

Anonymous — Fri, 06 Aug 2021 12:59:39 GMT

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.

Re: Show only common values from groups

lbendlin — Sun, 08 Aug 2021 03:10:52 GMT

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

Re: Show only common values from groups

Anonymous — Sun, 08 Aug 2021 04:37:50 GMT

I am not getting how to write the expression!

Re: Show only common values from groups

Anonymous — Sun, 08 Aug 2021 09:37:20 GMT

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

Re: Show only common values from groups

lbendlin — Sun, 08 Aug 2021 11:41:30 GMT

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

Re: Show only common values from groups

Anonymous — Tue, 10 Aug 2021 12:07:34 GMT

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

Re: Show only common values from groups

lbendlin — Tue, 10 Aug 2021 13:26:50 GMT

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

Re: Show only common values from groups

Anonymous — Tue, 10 Aug 2021 17:33:19 GMT

Link to the pbix

Kindly check the page 1 of the file.

Re: Show only common values from groups

Anonymous — Mon, 23 Aug 2021 07:13:12 GMT

Can someone help on this please!