Forum Discussion
admin_xlsior
Post Prodigy
Post ProdigyMatching between two unrelated tables
Hello guys, Need a few help with my case on finding match and unmatch between two unrelated table. I know I need to use LOOKUPVALUE for this, but somehow I can't get it right. So here is the ...
admin_xlsior
You mean like this? https://www.dropbox.com/t/RVZVoMC7wz3HEDPYRecommended People = VAR T1 = FILTER ( 'Person List', 'Person List'[Hobby] = SELECTEDVALUE ( 'Master Data'[ForHobby] ) && 'Person List'[Rent] = BLANK ( ) ) RETURN CONCATENATEX ( T1, [Person], UNICHAR ( 10 ) )Recommended Places = VAR T1 = SELECTCOLUMNS ( FILTER ( 'Person List', 'Person List'[Rent] = BLANK ( ) ), "@Hobby", 'Person List'[Hobby] ) RETURN CONCATENATEX ( FILTER ( 'Master Data', 'Master Data'[ForHobby] IN T1 ), 'Master Data'[Place], UNICHAR ( 10 ) )Number of People Rented = COUNTROWS ( 'Person List' )
tamerj1
Community Champion
Community ChampionHI admin_xlsior
Sory I did not understand the 2nd part of the question.
For the first part you can use https://www.dropbox.com/t/oLMQSLa6CxHS7MNF
Recommended People =
VAR T1 =
FILTER (
'Person List',
'Person List'[Hobby] = SELECTEDVALUE ( 'Master Data'[ForHobby] )
&& 'Person List'[Rent] = BLANK ( )
)
RETURN
CONCATENATEX (
T1,
[Person],
UNICHAR ( 10 )
)
admin_xlsiorPost Prodigy
Post ProdigyHi tamerj1
Let me digest and learn your pbix first, but it looks cool already 😀
Yeah, for the People's POV, means the table, column is People first. So if follows your table it may looks like :
And what I mean by Places and how many people rented is like this :
but this is very very simple, is just a simple Count. Just saying possiblity of reports.
Thank you very much.
- tamerj1
admin_xlsior
You mean like this? https://www.dropbox.com/t/RVZVoMC7wz3HEDPYRecommended People = VAR T1 = FILTER ( 'Person List', 'Person List'[Hobby] = SELECTEDVALUE ( 'Master Data'[ForHobby] ) && 'Person List'[Rent] = BLANK ( ) ) RETURN CONCATENATEX ( T1, [Person], UNICHAR ( 10 ) )Recommended Places = VAR T1 = SELECTCOLUMNS ( FILTER ( 'Person List', 'Person List'[Rent] = BLANK ( ) ), "@Hobby", 'Person List'[Hobby] ) RETURN CONCATENATEX ( FILTER ( 'Master Data', 'Master Data'[ForHobby] IN T1 ), 'Master Data'[Place], UNICHAR ( 10 ) )Number of People Rented = COUNTROWS ( 'Person List' )