Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Bikashjha
Frequent Visitor

Intersection between two Table visuals created in dashboard

I have created two table visuals on dashboard consists of one columns from main data source(present in Field). How can I find intersection between them.

 

Table 1 visual

Custid 

1

2

3

 

Table 2 visual

Custid 

4

5

3

 

Expected output Visual

Custid

3

 

 

 

 

 

5 REPLIES 5
TomMartens
Super User
Super User

Hey @Bikashjha ,

 

it's difficult to provide any solution or even guidance. As the information you provided is too scarce.

 

What is needed:

  • are the two table visuals fed by the same table of the Power BI dataset
  • what filters are active that influence the result of both table visuals

Nevertheless, you can consider creating a table that reflects on the intersection of "two tables" (assumption due to the scarce information) using the Merge transformation inside Power Query: Merge queries overview - Power Query | Microsoft Learn

 

The next images show how this can be achieved:

image.png

 

image.png

 

image.png

 

Hopefully, this provides an idea of how to tackle your challenge.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Hi @TomMartens ,

 

Thanks for the solution. But I want to find intersection between table visuals in dashboard(Table 1 and Table 2 in my case). Please find my dasboard on this link: https://drive.google.com/file/d/1VccYRCnyK_-rUleBwLuP6f1ildCg93Vr/view?usp=share_link

 

Let me know If you need anything else.

 

Thanks is advance😀

 

 

Hey @Bikashjha ,

 

I can tell you that this will not work, the reason is:

  • a table can not be generated from an existing table initiated by slicer selection

This means the model of the dataset has to be adjusted. I will think about a solution in the next couple of days.

 

Regards,

Tom

 



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Thanks @TomMartens  for the effort!

 

please let me know if I can solve this business problem through any other way in power bi

 

Thanks,

Bikash 

pratyashasamal
Super User
Super User

Hi @Bikashjha ,
You can use INTERSECT DAX function to find the intersection between two tables.
Syntax :- INTERSECT(<table_expression1>, <table_expression2>)

pratyashasamal_0-1676439376653.png

 

Please refer to this link :-
https://learn.microsoft.com/en-us/dax/intersect-function-dax

Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.