cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Showing grand total only in matrix/table

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

4 REPLIES 4
Highlighted
Community Support

## Re: Showing grand total only in matrix/table

Hi, @kundan3131

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.

Highlighted
Frequent Visitor

## Re: Showing grand total only in matrix/table

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

Highlighted
Community Support

## Re: Showing grand total only in matrix/table

Hi, @kundan3131

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.

Highlighted
Community Support

## Re: Showing grand total only in matrix/table

Hi, @kundan3131

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

Announcements

#### August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

#### July 2020 Community Highlights

Learn about the exciting things that happened in July.

#### Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

#### Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.