DAX Measure for getting percentage in a matrix

[ddanielc]

Hello, I have a measure as seen below, and I would like to create a new matrix table with the same Columns and Rows with the first Matrix, however, on the second matrix, I would like to display the percentage of the values to the total. For example, for M1.1, it will be 8% since 5/63 is 8%. To clarify, I need to have both matrices from left and right. How can I accomplish this?

Note that Sub1, Sub2, etc. are a list of subjects and for the Column Class, they can be expanded to subcategories like M1 to M1.1 and so on. 

 

[FreemanZ]

hi @ddanielc 

try to show the value field as percent of column total, like:

[ddanielc]

Hi @FreemanZ , I appreciate the reply.

Unfortunately, I don't see a "Show value as > Percent of column total" in mine. I think it might be because I'm using a Parameter Slicer as the value for the matrix. Hoping there's a way to proceed