Forum Discussion
Community ChampionMatrix Visual - Hide Percent Total
Community SupportHi rsbin
I understand. For a measure option, you could try ISINSCOPE function in the measure. Something like IF(ISINSCOPE('tablename'[columnname]),[measure],BLANK())
Example: total value corner matrix - Microsoft Power BI Community
BR,
Jing
Community ChampionHello v-jingzhang , tex628
Thank you for the suggestion of using ISINSCOPE. Since I am only using one column in my Matrix, I could not figure out how to make this fucntion work. But combining your suggestion with tex628 , I thought perhaps HASONEVALUE might work.
Audits_PercentBucketCount = IF(HASONEVALUE(FACT_SafetyAudits_ALL_NRT[6HourBucket_Local] ),
[Audit_PercentCount], BLANK() )
But this doesn't work either, because there are rows in my matrix where One Value for a Facility does occur and hence does not blank out the % in the Total Column. As tex628 mentioned,I need to "identify the % Totals" column and I am unable to figure out how to do this.
Thanks again for your efforts and suggestion to guide me along.
Best Regards,
- v-jingzhang
- rsbin
Hello v-jingzhang ,
Awesome. I got this latest solution to work. Thank you again very much for your time and efforts to resolve this one.
Kudos and Best Regards,