Please assist to create the column total

[Anonymous]

Hi,

I need some assistance to calculate the column total from the matrix.

I have attached a screenshot from my power BI.  I was able to get the column total from the matrix format.

Could anyone tell me how I can create a measure to calculate the column total?  For instance, unit 25 --> column total is 59.3; unit 27, column total is 84. I would need the column total to calculate the distribution of each term.

Thank you in advance for the supports! 

Thank you in advance for the supports! 

[Greg_Deckler]

Nope, didn't get that. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[amitchandak]

@Anonymous , Not very clear, You can use all except to create subtotals

Refer : https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390

[Anonymous]

Thanks! I applied ALLEXCEPT to the measure and it worked.

Really appreciate your assistance!