Forum Discussion
Solved
Totals in Matrix
Hi, I have created a matrix. The below data gets filtered on a slicer for Date. So for each date, there may be multiple records of O, P, or S for each org name (column1). I want a total as 3, if i...
Hi,
I have attached the sample data.
So the organisation here send multiple files. We are just interested if they send 1 of each file daily. So left side we capture the raw data , and the right I am trying to put it up in a matrix in power bi. I have the filter up for dates.
We would also like to see a trend of how many organisations are sending us all the 3 files , 2 etc.
| Download Type | Date | Code | Organisation Name | |
| UI | 15/09/2025 | SIDR-10700 | ABC | sender-id |
| UI | 15/09/2025 | SIDR-04875 | DEF | pa |
| UI | 15/09/2025 | SIDR-04875 | DEF | pa |
| API | 15/09/2025 | SIDR-04894 | PQR | sender-id |
| API | 15/09/2025 | SIDR-04894 | PQR | opa |
| API | 15/09/2025 | SIDR-04894 | PQR | pa |
| API | 15/09/2025 | SIDR-05215 | Telecom1 | opa |
| UI | 15/09/2025 | SIDR-05215 | Telecom1 | sender-id |
| API | 15/09/2025 | SIDR-05215 | Telecom1 | opa |
| UI | 16/09/2025 | SIDR-05497 | Apple 1 | sender-id |
| UI | 16/09/2025 | SIDR-05497 | Apple 1 | sender-id |
| API | 16/09/2025 | SIDR-04881 | Samsung1 | opa |
| API | 16/09/2025 | SIDR-04881 | Samsung1 | pa |
| API | 16/09/2025 | SIDR-04881 | Samsung1 | sender-id |
| API | 16/09/2025 | SIDR-05203 | Tiger1 | opa |
| UI | 16/09/2025 | SIDR-05203 | Tiger1 | sender-id |
| API | 16/09/2025 | SIDR-05203 | Tiger1 | opa |
| API | 16/09/2025 | SIDR-05213 | Dell 1 | opa |
| UI | 16/09/2025 | SIDR-05213 | Dell 1 | sender-id |
| API | 16/09/2025 | SIDR-05213 | Dell 1 | opa |
| API | 16/09/2025 | SIDR-05211 | Dell 1 | opa |
| UI | 16/09/2025 | SIDR-05211 | Dell 1 | sender-id |
| API | 16/09/2025 | SIDR-05211 | Dell 1 | opa |
| API | 17/09/2025 | SIDR-04871 | HP | opa |
| UI | 17/09/2025 | SIDR-04871 | HP | sender-id |
| UI | 17/09/2025 | SIDR-04871 | HP | opa |
| UI | 17/09/2025 | SIDR-04871 | HP | sender-id |
| API | 17/09/2025 | SIDR-04871 | HP | opa |
| UI | 17/09/2025 | SIDR-07873 | Dexatel OU | opa |
| UI | 17/09/2025 | SIDR-07873 | Dexatel OU | pa |
| UI | 17/09/2025 | SIDR-07873 | Dexatel OU | opa |
| UI | 17/09/2025 | SIDR-07873 | Dexatel OU | sender-id |
| UI | 17/09/2025 | SIDR-05747 | EMEA 1 | opa |
| UI | 17/09/2025 | SIDR-05747 | EMEA 1 | opa
|
Expected output
| 15/09/2025 | ||||
| Organisation Name | sender-id | pa | opa | Total |
| ABC | 1 | 1 | ||
| DEF | 2 | 1 | ||
| PQR | 1 | 1 | 1 | 3 |
| Telecom1 | 1 | 2 | 2 | |
| 16/09/2025 | ||||
| Organisation Name | sender-id | pa | opa | Total |
| Apple 1 | 2 | 1 | ||
| Samsung1 | 1 | 1 | 1 | 3 |
| Tiger1 | 1 | 2 | 2 | |
| Dell 1 | 2 | 4 | 2 | |
| 17/09/2025 | ||||
| Organisation Name | sender-id | pa | opa | Total |
| HP | 2 | 3 | 2 | |
| Dexatel QU | 1 | 1 | 2 | 3 |
| EMEA 1 | 2 | 1 |
Pasting the output again ,as the columns were too close
| 15/09/2025 | ||||
| Organisation Name | sender-id | pa | opa | Total |
| ABC | 1 | 1 | ||
| DEF | 2 | 1 | ||
| PQR | 1 | 1 | 1 | 3 |
| Telecom1 | 1 | 2 | 2 | |
| 16/09/2025 | ||||
| Organisation Name | sender-id | pa | opa | Total |
| Apple 1 | 2 | 1 | ||
| Samsung1 | 1 | 1 | 1 | 3 |
| Tiger1 | 1 | 2 | 2 | |
| Dell 1 | 2 | 4 | 2 | |
| 17/09/2025 | ||||
| Organisation Name | sender-id | pa | opa | Total |
| HP | 2 | 3 | 2 | |
| Dexatel QU | 1 | 1 | 2 | 3 |
| EMEA 1 | 2 | 1 |
Thank you,
Rains