Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Level up your Power BI skills this month - build one visual each week and tell better stories with data! Get started

Reply
rains_23
Helper I
Helper I

Totals in Matrix

‎09-16-2025 05:10 AM

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.

 

rains_23_2-1758024373576.png

 

 

rains_23_1-1758024339836.png

 

Expected Result

 

rains_23_3-1758024562403.png

 

 

 

 

 

Message 1 of 13
3,209 Views
0
1 ACCEPTED SOLUTION
lbendlin
Super User
Super User
In response to rains_23

‎10-29-2025 03:32 PM

lbendlin_0-1761777114544.png

 

View solution in original post

Message 5 of 13
1,791 Views
12 REPLIES 12
rains_23
Helper I
Helper I

‎10-14-2025 04:53 AM

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

Message 10 of 13
2,367 Views
0
lbendlin
Super User
Super User
In response to rains_23

‎10-15-2025 04:23 PM

Here is one example on how to achieve that

 

lbendlin_0-1760570551789.png

 

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

 

sum or count.pbix
Message 11 of 13
2,297 Views
0
rains_23
Helper I
Helper I
In response to lbendlin

‎10-22-2025 04:52 AM

@

lbendlin
Preview
 
rains_23_0-1761133913763.png

 

Part of it worked, It is not taking correctly when it has more count in only Type 1, 
 
 
 
 
Message 12 of 13
2,116 Views
0
lbendlin
Super User
Super User
In response to rains_23

‎10-22-2025 05:43 PM

Please post adjusted sample data and indicate expected result.

Message 13 of 13
2,092 Views
0
rains_23
Helper I
Helper I

‎09-23-2025 01:16 AM

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.

Message 9 of 13
2,919 Views
0
rains_23
Helper I
Helper I

‎09-23-2025 01:15 AM
Download TypeDateCodeOrganisation Name 
UI15/09/2025SIDR-10700ABCsender-id
UI15/09/2025SIDR-04875DEFpa
UI15/09/2025SIDR-04875DEFpa
API15/09/2025SIDR-04894PQRsender-id
API15/09/2025SIDR-04894PQRopa
API15/09/2025SIDR-04894PQRpa
API15/09/2025SIDR-05215Telecom1opa
UI15/09/2025SIDR-05215Telecom1sender-id
API15/09/2025SIDR-05215Telecom1opa
UI16/09/2025SIDR-05497Apple 1sender-id
UI16/09/2025SIDR-05497Apple 1sender-id
API16/09/2025SIDR-04881Samsung1opa
API16/09/2025SIDR-04881Samsung1pa
API16/09/2025SIDR-04881Samsung1sender-id
API16/09/2025SIDR-05203Tiger1opa
UI16/09/2025SIDR-05203Tiger1sender-id
API16/09/2025SIDR-05203Tiger1opa
API16/09/2025SIDR-05213Dell 1opa
UI16/09/2025SIDR-05213Dell 1sender-id
API16/09/2025SIDR-05213Dell 1opa
API16/09/2025SIDR-05211Dell 1opa
UI16/09/2025SIDR-05211Dell 1sender-id
API16/09/2025SIDR-05211Dell 1opa
API17/09/2025SIDR-04871HPopa
UI17/09/2025SIDR-04871HPsender-id
UI17/09/2025SIDR-04871HPopa
UI17/09/2025SIDR-04871HPsender-id
API17/09/2025SIDR-04871HPopa
UI17/09/2025SIDR-07873Dexatel OUopa
UI17/09/2025SIDR-07873Dexatel OUpa
UI17/09/2025SIDR-07873Dexatel OUopa
UI17/09/2025SIDR-07873Dexatel OUsender-id
UI17/09/2025SIDR-05747EMEA 1opa
UI17/09/2025SIDR-05747EMEA 1opa

 

 

 

15/09/2025    
Organisation Namesender-idpaopaTotal
ABC1  1
DEF 2 1
PQR1113
Telecom11 22
     
     
     
16/09/2025    
Organisation Namesender-idpaopaTotal
Apple 12  1
Samsung11113
Tiger11 22
Dell 12 42
     
     
17/09/2025    
Organisation Namesender-idpaopaTotal
HP2 32
Dexatel QU1123
EMEA 1  21
Message 8 of 13
2,919 Views
0
rains_23
Helper I
Helper I

‎09-18-2025 01:54 AM

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 TypeDateCodeOrganisation Name 
UI15/09/2025SIDR-10700ABCsender-id
UI15/09/2025SIDR-04875DEFpa
UI15/09/2025SIDR-04875DEFpa
API15/09/2025SIDR-04894PQRsender-id
API15/09/2025SIDR-04894PQRopa
API15/09/2025SIDR-04894PQRpa
API15/09/2025SIDR-05215Telecom1opa
UI15/09/2025SIDR-05215Telecom1sender-id
API15/09/2025SIDR-05215Telecom1opa
UI16/09/2025SIDR-05497Apple 1sender-id
UI16/09/2025SIDR-05497Apple 1sender-id
API16/09/2025SIDR-04881Samsung1opa
API16/09/2025SIDR-04881Samsung1pa
API16/09/2025SIDR-04881Samsung1sender-id
API16/09/2025SIDR-05203Tiger1opa
UI16/09/2025SIDR-05203Tiger1sender-id
API16/09/2025SIDR-05203Tiger1opa
API16/09/2025SIDR-05213Dell 1opa
UI16/09/2025SIDR-05213Dell 1sender-id
API16/09/2025SIDR-05213Dell 1opa
API16/09/2025SIDR-05211Dell 1opa
UI16/09/2025SIDR-05211Dell 1sender-id
API16/09/2025SIDR-05211Dell 1opa
API17/09/2025SIDR-04871HPopa
UI17/09/2025SIDR-04871HPsender-id
UI17/09/2025SIDR-04871HPopa
UI17/09/2025SIDR-04871HPsender-id
API17/09/2025SIDR-04871HPopa
UI17/09/2025SIDR-07873Dexatel OUopa
UI17/09/2025SIDR-07873Dexatel OUpa
UI17/09/2025SIDR-07873Dexatel OUopa
UI17/09/2025SIDR-07873Dexatel OUsender-id
UI17/09/2025SIDR-05747EMEA 1opa
UI17/09/2025SIDR-05747EMEA 1

opa

 

 

 

Expected output

15/09/2025    
Organisation Namesender-idpaopaTotal
ABC1  1
DEF 2 1
PQR1113
Telecom11 22
     
     
     
16/09/2025    
Organisation Namesender-idpaopaTotal
Apple 12  1
Samsung11113
Tiger11 22
Dell 12 42
     
     
17/09/2025    
Organisation Namesender-idpaopaTotal
HP2 32
Dexatel QU1123
EMEA 1  21

 

 

Pasting the output again ,as the columns were too close 

 

15/09/2025    
Organisation Namesender-idpaopaTotal
ABC1  1
DEF 2 1
PQR1113
Telecom11 22
     
     
     
16/09/2025    
Organisation Namesender-idpaopaTotal
Apple 12  1
Samsung11113
Tiger11 22
Dell 12 42
     
     
17/09/2025    
Organisation Namesender-idpaopaTotal
HP2 32
Dexatel QU1123
EMEA 1  21

Thank you,

Rains

Message 7 of 13
3,040 Views
0
lbendlin
Super User
Super User

‎09-16-2025 05:43 PM

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-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Message 2 of 13
3,124 Views
0
rains_23
Helper I
Helper I
In response to lbendlin

‎10-29-2025 02:47 AM

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...

 

@lbendlin 

Message 4 of 13
1,853 Views
0
lbendlin
Super User
Super User
In response to rains_23

‎10-29-2025 03:32 PM

lbendlin_0-1761777114544.png

 

Message 5 of 13
1,792 Views
rains_23
Helper I
Helper I
In response to lbendlin

‎10-30-2025 02:31 AM

Thank you, it worked.

 

I accepted it as a solution.

 

Thanks a million.

 

Rains

 

Message 6 of 13
1,763 Views
0
rains_23
Helper I
Helper I
In response to lbendlin

‎10-06-2025 01:41 AM

Hi,

I have uploaded the data here,

 

https://docs.google.com/spreadsheets/d/135t1iSDz59lNGk1npZ629_IOkz7ZR1b6/edit?usp=drive_link&ouid=10...

 

Thank You,

Rains

Message 3 of 13
2,505 Views
0

Helpful resources

Announcements
April Power BI Update Carousel

Power BI Monthly Update - April 2026

Check out the April 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All
Top Solution Authors
View All
Top Kudoed Authors
View All