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!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register 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 |