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: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

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
1,533 Views
0
1 ACCEPTED SOLUTION
lbendlin
Super User
Super User
In response to rains_23

Wednesday

lbendlin_0-1761777114544.png

 

View solution in original post

Message 5 of 13
115 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
691 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
621 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
440 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
416 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
1,243 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
1,243 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
1,364 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
1,448 Views
0
rains_23
Helper I
Helper I
In response to lbendlin

Wednesday

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
177 Views
0
lbendlin
Super User
Super User
In response to rains_23

Wednesday

lbendlin_0-1761777114544.png

 

Message 5 of 13
116 Views
rains_23
Helper I
Helper I
In response to lbendlin

Thursday

Thank you, it worked.

 

I accepted it as a solution.

 

Thanks a million.

 

Rains

 

Message 6 of 13
87 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
829 Views
0

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All