Forum Discussion

corbusier's avatar
corbusier
Icon for Advocate IV rankAdvocate IV
8 years ago
Solved

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 r...
Need Help
  • v-xjiin-msft's avatar
    v-xjiin-msft
    8 years ago

    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.

     

     

v-xjiin-msft's avatar
v-xjiin-msft
Icon for Solution Sage rankSolution Sage
8 years ago

corbusier

 

Did you mean this?

 

 

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.

corbusier's avatar
corbusier
Icon for Advocate IV rankAdvocate IV
8 years ago

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? 

  • v-xjiin-msft's avatar
    v-xjiin-msft
    Icon for Solution Sage rankSolution Sage
    8 years ago

    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.