Forum Discussion
Table visual help
Dear community,
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
any help on this will be highly appreciated
14 Replies
You will need to write your measure according to ignore your filtering at the Total level. Take a look at this Quick Measure, Measure Totals, The Final Word as you should be able to use the technique here to get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907Hi vjnvinod
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.
Test = IF ( HASONEVALUE ( Table3[Column1] ), CALCULATE ( SUM ( Table3[Column2] ) ), CALCULATE ( SUM ( Table3[Column2] ), ALL ( Table3[Column1] ) ) )Regards,
Cherie
Hi take a look at the below sample.
i wasn't sucesfull to get there, may be because i am not good at caculating measure.
in this test file, i basically don't want to see cbs & elim & unclassified, but the total should remain same.
Apprecaite your help
https://www.dropbox.com/s/jvpzkfyq82w6540/Test.pbix?dl=0
Regards, vinod
Hi vjnvinod
You may try to use below measure and set the visual level filter as below:
Test = IF ( HASONEVALUE ( Inbound[Line] ), CALCULATE ( SUM ( Inbound[TER_FYTD_USD] ) ), CALCULATE ( SUM ( Inbound[TER_FYTD_USD] ), ALL ( Inbound[Line] ) ) )Regards,
Cherie
