Take a look at the below pic. its a table visual in power BI
my problem is, i need to hide or filter out some fileds lets say the one you see here "im" which has -57.1M. while we do that we also need to make sure the total is unaffected.(that means even i take off/hide "-57.1M", my total should remain as 851.6M
You may use visual level filter to hide some fileds.Then you may create a measure with HASONEVALUE Function. Show a simplified sample as below. If it is not your case, please share some sample data for your scenario so that we could help further on it.
HASONEVALUE ( Table3[Column1] ),
CALCULATE ( SUM ( Table3[Column2] ) ),
CALCULATE ( SUM ( Table3[Column2] ), ALL ( Table3[Column1] ) )
Community Support Team _ Cherie Chen If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I did a test, i think this measure doesn't works perfectly, i see the revenue numbers are ok with this measure but the growth% are affecting while filtering the fields in the visual filters, refer below pics