Show selected filter and others

[Raulx_7]

Hi I have a matrix like this 

User

       Rey

           - Item 1

           - Item 2

           - Item 3

       Reo

           - Item 2

           - Item 7

           - Item 19

       Roy

           - Item 8

           - Item 7

           - Item 5

With item filter, when I select the specific item, the matrix only shows that item. What I want to display is all the users that have that item.

If I select in the filter Item 7, it should shows: 

User

       Reo

           - Item 2

           - Item 7

           - Item 19

       Roy

           - Item 8

           - Item 7

           - Item 5

[v-yalanwu-msft]

Hi, @Raulx_7 ;
It would be nice if you could share samples, and it's hard for me to know why you're not working.

Thank you.

How to upload PBI in Community

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @Raulx_7 ;

Sorry ,  There was one step I forgot to write.

You could try it. 

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Raulx_7]

is still not working, mi problem is that the column (item) is linked with other. however, if I cancel that link, does not filter nothing. 

(relation only item names table and global table where clients are stored)

If I keep the relation, the matrix only shows the selected item (even with the flag filter), If I remove the relation, I select an item and nothing happens. 

[Raulx_7]

Those measures, will go instead of the item column in my rows on the matrix? or instead of both columns, items and user?

[v-yalanwu-msft]

Hi, @Raulx_7 ;

You also could create a flag measure.

flag = 
var _a  = SUMMARIZE(FILTER(ALL('Table'),[Item] in VALUES('Item'[Item])),[User])
return
IF( MAX('Table'[User]) in _a,1)

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Raulx_7]

This is not working for me, I have the 3 tables, 1 with only the items (for filter), other of users (here are the users), and products (here are the items, with other data).

I've created the flag, however, it only shows the selected item. 

This is how I've defined the flag: 

flag =

var _a  = SUMMARIZE(FILTER(ALL('OrderDetail'),[name] in VALUES('OrderDetail'[name])),'User'[Cliente])

return

IF( MAX('User'[Cliente]) in _a,1)

[amitchandak]

@Raulx_7 , Item slicer should be coming from an independent table

measure =

var _tab  = summarize(filter(allselected(Table),Table[Item] in values(Item[Item]) ) , Table[User])

return

countrows(filter(Table, Table[User] in _tab) )

use this measure

[Raulx_7]

Where should I use this measure? as a filter?