HELP NEEDED : Determining the percentage contribution of a matrix cell value of a calculated total

[RossChevalier]

Hi folks,

I am gapping on how to do what I think should be simple.

I have a matrix visual that is working very well using basic sum aggregation for the columns as shown below.

My user would like an additional column in the matrix that shows what percentage of the total each product makes up for each location.  The locations are the first row set in the matrix and the products are the second row set in the matrix.

As an example, the % value for the first product (Bathurst PMO) would be 97753 / 1785017 displayed as a percentage to two decimal places (5.48%)  Since I do not know the total for the location until the matrix is visualized, I do not know how to create the measure or column to hold the percentages.  

I feel that I am missing something incredibly obvious.  Assistance will be very much appreciated.

[RossChevalier]

Thank you so much for your assistance!  I would not have gotten here without your help.  Brilliant!

[DataInsights · Accepted solution]

@RossChevalier,

Try these measures. ALLSELECTED removes visual-level filters from Product, but keeps filters from outside the visual (e.g., slicer). ALL can be used instead of ALLSELECTED; just be sure to understand the difference.

Total Volume FBM = SUM ( Table1[Volume FBM] )

Product % of Location = 
VAR vNumerator = [Total Volume FBM]
VAR vDenominator =
    CALCULATE ( [Total Volume FBM], ALLSELECTED ( Table1[Product] ) )
VAR vResult =
    DIVIDE ( vNumerator, vDenominator )
RETURN
    vResult