Total row in Tables and Matrix, to include all values including filtered (hidden) data

[Anonymous]

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

[Anonymous]

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.

https://www.youtube.com/watch?v=44QUjA5NDwY

[Anonymous]

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. 

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may refer to the post below.

https://community.powerbi.com/t5/Desktop/Hide-matrix-rows-without-affecting-values/m-p/646134#M309686