topic Re: Totals in Matrix in Custom Visuals Development Discussion

Totals in Matrix

rains_23 — Tue, 16 Sep 2025 12:10:20 GMT

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 it has atleast 1 record in each. A total of 2 if 1 record in atleast O , P or S.

So I created an additional column and added value 1 in each, but I get the second table with distinct count. When I do total, it still shows 1 and not what I expect.

what can I do to solve this.

Expected Result

Re: Totals in Matrix

lbendlin — Wed, 17 Sep 2025 00:43:55 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Totals in Matrix

rains_23 — Thu, 18 Sep 2025 08:55:40 GMT

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

Re: Totals in Matrix

rains_23 — Tue, 23 Sep 2025 08:15:58 GMT

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

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

Re: Totals in Matrix

rains_23 — Tue, 23 Sep 2025 08:16:53 GMT

I tried pasting it as a table, but seems not working as it is getting rid of the html. I will try to upload it later, as cannot use any drive in office.

Re: Totals in Matrix

rains_23 — Mon, 06 Oct 2025 08:41:56 GMT

Hi,

I have uploaded the data here,

https://docs.google.com/spreadsheets/d/135t1iSDz59lNGk1npZ629_IOkz7ZR1b6/edit?usp=drive_link&ouid=105535431888411202482&rtpof=true&sd=true

Thank You,

Rains

Re: Totals in Matrix

rains_23 — Tue, 14 Oct 2025 11:53:29 GMT

@lbendlin Just tagging you in case you missed my reply. I have uploaded the data in a spreadsheet in google sheets.

Re: Totals in Matrix

lbendlin — Wed, 15 Oct 2025 23:23:33 GMT

Here is one example on how to achieve that

Maybe rename "Totals" to something else to lessen the user confusion.

Re: Totals in Matrix

rains_23 — Wed, 22 Oct 2025 11:52:10 GMT

lbendlin

Preview

Part of it worked, It is not taking correctly when it has more count in only Type 1,

Re: Totals in Matrix

lbendlin — Thu, 23 Oct 2025 00:43:40 GMT

Please post adjusted sample data and indicate expected result.

Re: Totals in Matrix

rains_23 — Wed, 29 Oct 2025 09:47:20 GMT

It's the same data, except the condition was not added. I have amended the data in the same sheet now.

https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.google.com%2Fspreadsheets%2Fd%2F135t1iSDz59lNGk1npZ629_IOkz7ZR1b6%2Fedit%3Fusp%3Ddrive_link%26ouid%3D105535431888411202482%26rtpof%3Dtrue%26sd%3Dtrue&data=05%7C02%7Crenu.agrawal-dongre%40comreg.ie%7Cf63f38333b294fe4cfc808de04b413c3%7C7e3063639dee4b8d8a6b4fee706b37fa%7C0%7C0%7C638953368677174665%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=CeZjmCSuxZG2QuVZTCUVMQnzHkstKoEpQd0T6YkM%2Fks%3D&reserved=0

@lbendlin

Re: Totals in Matrix

lbendlin — Wed, 29 Oct 2025 22:32:01 GMT

Re: Totals in Matrix

rains_23 — Thu, 30 Oct 2025 09:31:09 GMT

Thank you, it worked.

I accepted it as a solution.

Thanks a million.

Rains