Different Aggregation for Matrix Columns

[jinyli]

Hi everyone!

I'm running into a problem when using matrix. I want to show 3 fields: value, total count and the percentage. Percentage is a calculated column computed with value/total. 

The problem is that each field has to be summarized in some way since there are slicers on the data. I used Sum for value and total acount, and there's no issue. However I don't know how I should summarize the percentage. Simply taking average of them, like I did in the picture,  is clearly wrong. You see that the percentages aren't equal to value/total count. Ideally I want the percentage to be dynamic, always reflecting value/total count. Is there any way to do it in matrix? If not, what visualization should I choose, if I want to see the 3 fields in 2 dimensions(date and product) ?

Thanks!

[Nathaniel_C · Accepted solution]

Hi @jinyli ,

Two pictures below. First a table named Matrix with truncated portion of your values. Second contains the measure P1 and the matrix visual. Instead of using the column PERCENT use the measure to show the percentage. Just remember to format your measure  as a percentage.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

 

[jinyli]

Solved my problem. Thank you so much!