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.
Hello,
Is it possible to show the Grand Total for the last column only?
The other columns cannot be added.
I can either work with a table or matrix.
Solved! Go to Solution.
Hi again @webportal
Just create calculated measures over the columns that you don't want the total.
Then wrap the new measure to only show values on the rows. You'll need to point the [Category] column to something that you are actually using in your table visual (one of the ones we can't see)
Sum of Quant. = IF( ISFILTERED('Códigos e valores'[Category]), SUM('Csv'[Quant.]) )
Hi again @webportal
Just create calculated measures over the columns that you don't want the total.
Then wrap the new measure to only show values on the rows. You'll need to point the [Category] column to something that you are actually using in your table visual (one of the ones we can't see)
Sum of Quant. = IF( ISFILTERED('Códigos e valores'[Category]), SUM('Csv'[Quant.]) )
Actually, I'm trying with:
Measure = IF(ISFILTERED('Table'[Category]);SUM([Quant.]))
This hides the grand total but then it doesn't summarize rows by Category, ie, it shows all the items.
So all rows get a 1 for the measure above.
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |