Dear All
I am new to PowerBI, I created some simple dashboards related to normal cumulated measures for stock and sales.
However, this is the first time more to try to create a dashboard that has a matrix table getting the data based on the distinct total number of Frames based on two different dates and different filtering criteria.
FACT TABLE
| Frame | Brand | PlannedMY | Job No | Job Start | Job End | Job Group | Job Code | Status |
| T7290336 | C | Jul-21 | | | | NON-EES | TSHG090 | Pending |
| T8270028 | A | Jun-21 | JC-0000137 | 6/20/2021 | 6/20/2021 | EES | TSHG001 | Completed |
| T8270028 | A | Jun-21 | JC-0000137 | 6/20/2021 | 6/20/2021 | EES | TSHG012 | Completed |
| T8270028 | A | Jun-21 | | | | EES | TSHG032 | Pending |
| T8270028 | A | Jun-21 | | | | NON-EES | TSHG034 | Pending |
| T8270028 | A | Jun-21 | JC-0000139 | 3/11/2021 | | EES | TSHG088 | WIP |
| T8270028 | A | Jun-21 | JC-0000139 | 3/11/2021 | | NON-EES | TSHG089 | WIP |
| T8270028 | A | Jun-21 | JC-0000139 | 3/11/2021 | | NON-EES | TSHG090 | WIP |
| T8270321 | A | May-21 | JC-0000155 | 3/19/2021 | 4/19/2021 | EES | TSHG001 | Completed |
| T8270321 | A | May-21 | JC-0000155 | 3/19/2021 | 4/19/2021 | EES | TSHG032 | Completed |
| T8270322 | A | Mar-21 | JC-0000133 | 3/12/2021 | | EES | TSHG012 | WIP |
| T8270322 | A | Mar-21 | JC-0000134 | 3/23/2021 | 3/25/2021 | EES | TSHG032 | Completed |
| T8270322 | A | Mar-21 | JC-0000133 | 3/12/2021 | | NON-EES | TSHG034 | WIP |
| T8270325 | C | Jun-21 | JC-0000784 | 5/19/2021 | 4/19/2021 | EES | TSHG001 | Completed |
| T8270325 | C | Jun-21 | JC-0000786 | 5/19/2021 | | EES | TSHG012 | WIP |
| T8270325 | C | Jun-21 | JC-0000784 | 5/19/2021 | 4/19/2021 | EES | TSHG032 | Completed |
| T8270326 | A | Jun-21 | | | | EES | TSHG001 | Pending |
| T8270326 | A | Jun-21 | | | | EES | TSHG012 | Pending |
| T8270326 | A | Jun-21 | | | | EES | TSHG032 | Pending |
| T8270326 | A | Jun-21 | | | | NON-EES | TSHG034 | Pending |
| T8270334 | C | Feb-21 | JC-0000096 | 6/12/2021 | 6/12/2021 | NON-EES | TSHG090 | Completed |
| T8270335 | C | Jun-21 | JC-0000786 | 6/11/2021 | 6/11/2021 | NON-EES | TSHG090 | Completed |
| T8270336 | C | Mar-21 | JC-0000148 | 6/2/2021 | 6/2/2021 | NON-EES | TSHG090 | Completed |
The matrix should look like the following
EES Current Month Cumulative TOTAL
| Brand | Planned | Completed | Variance | Planned | Actual | Variance | Planned | Completed | Variance |
| A | 2 | 1 | 1 | 4 | 3 | 1 | 4 | 3 | 1 |
| C | 1 | | 1 | 1 | 1 | 0 | 1 | 1 | 0 |
