Calculating percentages based on two dimensions and one measure

[10500438]

I have a data set that has 2 dimensions, one is called "Grouping" and one is called "Market Segment. The measure (value) is "Billed MT".

I want to create another measure that is a percentage of the Billed MT that calculates out to the percentages below.

I need one measure that calculates called "% of Billed Qty" because I will put it in a Matrix to look like this below.

My boss will not let me change the format, please help, thanks!!

[v-jiascu-msft]

Hi @10500438,

Could you please mark the proper answers as solutions?

Best Regards,

[tarunsingla · Accepted solution]

Matrix allows to show values as Percentages. Have you checked this in the Values section.  Drop the field (Sum of Billed MT) onto the values section of the Matrix visual. Then right click the field there and look for options. Show Value As Percentage of Row Total should help.

Regards,

Tarun

Did I answer your question? Mark my post as a solution!

[10500438]

Thank you, this worked great!!