The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 |
User | Count |
---|---|
65 | |
62 | |
60 | |
53 | |
28 |
User | Count |
---|---|
181 | |
82 | |
67 | |
47 | |
44 |