Intersect 2 unrelated table for listing only

[VoltesDev]

Hi guys,

How to display a list of rows by comparing a same cattegory (value) but wihout any calculation in it ? 

Example, I have data like this :

And I have table Product :

So I want the table list only display the matched Business Profile. This two table are unrelated, but I want to compare between that Business Profile. Another thing is can we not create new table, so just in that display (table visual) only.

Thanks,

[v-kkf-msft · Accepted solution]

Hi @VoltesDev ,

Please create the measure and use it as a visual-level filter.

Measure = 
COUNTROWS (
    INTERSECT (
        VALUES ( 'Product'[Business Profile] ),
        VALUES ( Data[Business Profile] )
    )
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@VoltesDev , you can  create a measure and use that in the filter or can use it as visual level filter and check for not blank

countrows(filter(Table2, Table2[Business Profile] in allselected(Table1[Business Profile]) )

You can also use treatas

https://docs.microsoft.com/en-us/dax/treatas-function

[VoltesDev]

Hi @amitchandak 

May I know why in my measure when I test, the ALLSELECTED is not working ?

My display is like this : 

This is on the report page, and it is filtered by other table related to it.

I tried to test the ALLSELECTED with a new table in Data section, but all rows come out ->

Is the filtered lost in Data Section ?

Thanks