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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Anonymous
Not applicable

Look for value of 2 unrelated tables

Hi,

 

I post again my issue and try to make it clear this time. Hope you can help. Many thanks !!!

Here is the pbix drive.google.com

 

The expecting result is a matrix that I can filter the overstated and missing value(s): 

 

sectionCenterClustervLan 1 (vlan)vLan 2 (PortVLAN)Overstated [vLan 2] - [vLan 1]Missing [vLan 1] - [vLan 2]
CATE800V006BBALR00353353520
CATE800V006BBALR00453353520
CATE800V006BBILR00253353960
CATE800V006BBILR00353353960
CATE800V006BBTLR00253353300
CATE800V007BBAWI00253353520
CATE800V007BBIWI00253353520
CATE800V007BGWI00353353520
COME000V002BBAWI001692704120
COME000V002BBWI001692704120
COME000V002BGMU999692704120
COME000V002BGWI001692704120
COME000V002BGWI002692704120
COME000V003BBALR001692705130
COME000V003BBLR001692705130
COME000V003BGTLR001692705130
COME000V003BGTLR003692704120
SIA  870087

 

This matrix should be filtered on the Overstated and Missing values.  

Filter
1. Overstated
2. Missing

For example, when select Overstated option, the matrix will show the overstated vLan

sectionCenterClustervLanvLan 1 (vlan)vLan 2 (PortVLAN)Overstated [vLan 2] - [vLan 1]Missing [vLan 1] - [vLan 2]
CATE800V006BBALR003 53353520
   225    
   920    
CATE800V006BBALR004 53353520
   225    
   920    
CATE800V006BBILR002 53353960
   1939    
   1963    
   2198    
   3003    
   3005    
   3006    
CATE800V006BBILR003 53353960
   1939    
   1963    
   2198    
   3003    
   3005    
   3006    
CATE800V006BBTLR002 53353300
CATE800V007BBAWI002 53353520
   225    
   920    
CATE800V007BBIWI002 53353520
   225    
   920    
0 REPLIES 0

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors