cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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.

a1.png

 

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

g1.png

 

Then I created measures as follows.

 

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

 

 

Result:

g2.png

 

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

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

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

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

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

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.

Power BI Desktop August 2020 Update

Power BI Desktop August 2020 Update

We have great updates this month! Click the link for the video with more info.

Top Solution Authors
Top Kudoed Authors