Forum Discussion

rsbin's avatar
rsbin
Community Champion
4 years ago
Solved

Matrix Visual - Hide Percent Total

Good Afternoon, Have a Matrix Visual showing Value and Percentage.  In the Value dropdown, I am using the option to "Show as % of row total" The Percentage Total of 100% is redundant.  Is it ...
Need Help
rsbin's avatar
rsbin
Community Champion
4 years ago

Hello 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,

  • rsbin's avatar
    rsbin
    Community Champion
    4 years ago

    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,