Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Exclude Matrix Column from Subtotal

Hi All,   I am using a Matrix visual to display my data. My data is broken out into five columns provided by the customer: - Year - Month - Tier - Number of Records - Percent of Records   Th...
Need Help
Icey's avatar
Icey
Community Support
5 years ago

Hi Anonymous ,

 

How is your measure written?

I don't know your data structure and create a simple example. Try to create a measure like so:

Percent of Records =
SUM ( 'Table'[Number of Records] )
    / CALCULATE (
        SUM ( 'Table'[Number of Records] ),
        ALLEXCEPT ( 'Table', 'Table'[Month], 'Table'[Year] )
    )

 

If it doesn't work, please share us some sample data for test.

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.