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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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