topic Re: DAX Measure for getting percentage in a matrix in DAX Commands and Tips

DAX Measure for getting percentage in a matrix

ddanielc — Wed, 25 Oct 2023 03:39:27 GMT

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.

Re: DAX Measure for getting percentage in a matrix

FreemanZ — Wed, 25 Oct 2023 04:00:00 GMT

hi ddanielc

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

Re: DAX Measure for getting percentage in a matrix

ddanielc — Wed, 25 Oct 2023 04:05:23 GMT

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