Forum Discussion
Find Commonalities
Hi every one
I am some how new to power bi and now have challenge with a problem.
I made a visual table with these conditions.
Company filter, has chosen and also column ‘status’ = “ordered”
And have another table with these conditions.
SubIndustrial filtered has chosen and also column ‘status’ <> “ordered”
In these 2 tables we have a common column, named Branding.
How can I get the common branding items between these tables?
I used some Dax functions but it gave me blank
I would be appreciate if you help me
Hi, MohsenGhandi
According to your description, your needs are not hard to achieve, But I don't know what effect do you want.
You can put these three columns(Company,SubIndustrial,Branding) in the same table and create a measure to filter data you want in filter pane, then it will show the brand that fits the two situations.
Like this：
measure = IF ( SELECTEDVALUE ( table[company] ) = "ordered" && SELECTEDVALUE ( table[subindustial] ) <> "ordered", 1, 0 )Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Best Regards,Community Support Team _ Janey
4 Replies
- amitchandak
Super User
with common table branding plot this measure
if(not(isblank(countrows(Table1))) && not(isblank(countrows(Table2))) , 1, blank())
My table is not in query
It’s the visual table
What should I put instead of table1 and 2?- v-janeyg-msft
Community Support
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If problem still persists, pls let me know.Best Regards,
Community Support Team _ Janey
- v-janeyg-msft
Hi, MohsenGhandi
According to your description, your needs are not hard to achieve, But I don't know what effect do you want.
You can put these three columns(Company,SubIndustrial,Branding) in the same table and create a measure to filter data you want in filter pane, then it will show the brand that fits the two situations.
Like this：
measure = IF ( SELECTEDVALUE ( table[company] ) = "ordered" && SELECTEDVALUE ( table[subindustial] ) <> "ordered", 1, 0 )Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Best Regards,Community Support Team _ Janey
