cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate III
Advocate III

Show Count in Totals row without summarizing column

Hello all, I have a Matrix visual that I'm using to list attributes (measures) related to Products. For example, Sales, Revenue etc. The sum of Sales and Revenues works and shows fine in the Totals row. Now I want to add the count of Products. How do I do this, without adding a column with 1 for each row of Product?

 

for example,

 

Product | Code | Sales | Revenue  

Prod A  | BRE |  700 | 700000

Prod B  | GHR | 500 | 600000  

Totals   | 2 | 1300 | 1300000

 

Any help is appreciated! 

1 ACCEPTED SOLUTION

@corbusier

 

No. I'm afraid it is not possible. Matrix can not count the Total for srouce table itself. We should give Matrix a value.

 

Thanks,
Xi Jin.

 

 

View solution in original post

3 REPLIES 3
Solution Sage
Solution Sage

@corbusier

 

Did you mean this?

 

sa.PNG

 

If you want to get the count of Products. You can simply put the Product column into Values of Matrix visual and choose Count. And if you want to use measure to calculate the total count of products, you can try COUNTROWS(tablename).

 

If above sample doesn't satisfy your requirement, could you please share us more detailed information like some screenshots of your Matrix and your desired result if possible?

 

Thanks,
Xi Jin.

This works, but inserts a column. I'm trying to not have a column that just has "1" on every row to get the total count since it's ugly. Is it possible to have the count on the Total row without having a column for it? 

@corbusier

 

No. I'm afraid it is not possible. Matrix can not count the Total for srouce table itself. We should give Matrix a value.

 

Thanks,
Xi Jin.

 

 

View solution in original post

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors