Showing grand total only in matrix/table

[Anonymous]

Hi all,

I have 5 columns in the table and I wanted to hide all the rows and show grand total only means, I want column name and grand total of the respective column. but I am unable to do that.

can anyone help me here??

[v-alq-msft]

Hi, @Anonymous 

Based on your description, I wonder if the five columns are all number data type. If there are five number columns, they will be summed by default. Here is an example.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

no, I have one column of a text data type. is it possible to hide all the rows like we can do it in tableau and show column name and grand total only

[v-alq-msft]

Hi, @Anonymous 

I wonder what you want to display on the grand total of the text column(Min,Max,Count,...).

Here is my sample data.

Then I created measures as follows.

MinName = MIN('Table'[Name])
MaxName = MAX('Table'[Name])
CountName = COUNT('Table'[Name])

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-alq-msft]

Hi, @Anonymous 

If you take the answer of someone, please mark it as the solution to help the other members who have same problems find it more quickly. If not, let me know and I'll try to help you further. Thanks.

Best Regards

Allan