Matrix visual

[freddoune]

Hello all,

I have a matrix with in column the month and in the row the countries and in the values my measure

I added the total per row and per column. I would like to know if it's possible to add the %of the column total as decribed below.

Thanks for your support 

Frédéric

[girishthimmaiah]

Yes, you can add a new column in your Power BI matrix visual to display the percentage of the column total. Here’s how to do it:

Steps to Add % of Column Total: Create a New Measure You need to add a DAX measure that calculates the percentage of the total for each row.

DAX  % of Column Total = DIVIDE( SUM('YourTable'[YourMeasure]), CALCULATE( SUM('YourTable'[YourMeasure]), ALL('YourTable'[Country]) ) ) SUM('YourTable'[YourMeasure]): This calculates the sum of the measure for each row. CALCULATE(SUM('YourTable'[YourMeasure]), ALL('YourTable'[Country])). This computes the total sum across all countries, removing the country filter. DIVIDE(...): This ensures safe division to prevent errors when dividing by zero.

Add the Measure to the Matrix Drag this measure into the Values field in the matrix. Change the format to percentage using the Measure Tools ribbon. Place it in the Rightmost Column If necessary, adjust the matrix column subtotals to make sure this new measure appears correctly. This will show the percentage of each country’s total in relation to the overall total.

[freddoune]

Thanks for the feedback

if i apply your solution in the column i'll have both my measure and the % whereas i only want to display the percentage near the total column. How can remove these columns. Thanks