Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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??
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.
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
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |