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 am looking for a way of making sure the total row at the bootom of a table adds all values from that column, instead of just the values that aren't filtered.
Is there a way that you can do this in a table or a matrix?
In other words if half the rows are filtered I'd still like the total to match the value of all rows (filtered and un filtered).
Thank you
Solved! Go to Solution.
@RCC ,
You may refer to the post below.
Here's a great video that gives an idea of how to do something similar. The only thing you would need to add would be a filter with ALL or ALLEXCEPT to make sure that no filters or only some filters are being applied to the total value.
Thank you for that link, but I don't think it has helped answer my Query.
What I am looking for is a way of locking the total function in Power Bi to ignore the filters.
This is just an excel screenshot to show what I mean. When I've filtered out the sample 'A' the total is still the same.
@RCC ,
You may refer to the post below.
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 |
---|---|
106 | |
105 | |
86 | |
73 | |
66 |
User | Count |
---|---|
124 | |
113 | |
98 | |
81 | |
72 |