Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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):
| section | Center | Cluster | vLan 1 (vlan) | vLan 2 (PortVLAN) | Overstated [vLan 2] - [vLan 1] | Missing [vLan 1] - [vLan 2] |
| CAT | E800V006 | BBALR003 | 533 | 535 | 2 | 0 |
| CAT | E800V006 | BBALR004 | 533 | 535 | 2 | 0 |
| CAT | E800V006 | BBILR002 | 533 | 539 | 6 | 0 |
| CAT | E800V006 | BBILR003 | 533 | 539 | 6 | 0 |
| CAT | E800V006 | BBTLR002 | 533 | 533 | 0 | 0 |
| CAT | E800V007 | BBAWI002 | 533 | 535 | 2 | 0 |
| CAT | E800V007 | BBIWI002 | 533 | 535 | 2 | 0 |
| CAT | E800V007 | BGWI003 | 533 | 535 | 2 | 0 |
| COM | E000V002 | BBAWI001 | 692 | 704 | 12 | 0 |
| COM | E000V002 | BBWI001 | 692 | 704 | 12 | 0 |
| COM | E000V002 | BGMU999 | 692 | 704 | 12 | 0 |
| COM | E000V002 | BGWI001 | 692 | 704 | 12 | 0 |
| COM | E000V002 | BGWI002 | 692 | 704 | 12 | 0 |
| COM | E000V003 | BBALR001 | 692 | 705 | 13 | 0 |
| COM | E000V003 | BBLR001 | 692 | 705 | 13 | 0 |
| COM | E000V003 | BGTLR001 | 692 | 705 | 13 | 0 |
| COM | E000V003 | BGTLR003 | 692 | 704 | 12 | 0 |
| SIA | 87 | 0 | 0 | 87 |
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
| section | Center | Cluster | vLan | vLan 1 (vlan) | vLan 2 (PortVLAN) | Overstated [vLan 2] - [vLan 1] | Missing [vLan 1] - [vLan 2] |
| CAT | E800V006 | BBALR003 | 533 | 535 | 2 | 0 | |
| 225 | |||||||
| 920 | |||||||
| CAT | E800V006 | BBALR004 | 533 | 535 | 2 | 0 | |
| 225 | |||||||
| 920 | |||||||
| CAT | E800V006 | BBILR002 | 533 | 539 | 6 | 0 | |
| 1939 | |||||||
| 1963 | |||||||
| 2198 | |||||||
| 3003 | |||||||
| 3005 | |||||||
| 3006 | |||||||
| CAT | E800V006 | BBILR003 | 533 | 539 | 6 | 0 | |
| 1939 | |||||||
| 1963 | |||||||
| 2198 | |||||||
| 3003 | |||||||
| 3005 | |||||||
| 3006 | |||||||
| CAT | E800V006 | BBTLR002 | 533 | 533 | 0 | 0 | |
| CAT | E800V007 | BBAWI002 | 533 | 535 | 2 | 0 | |
| 225 | |||||||
| 920 | |||||||
| CAT | E800V007 | BBIWI002 | 533 | 535 | 2 | 0 | |
| 225 | |||||||
| 920 |
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!