DAX for percentage values

Hi devdev 

The following dax measure should make the calculation you need

Percentage of Total Cost =
DIVIDE(
SUM('YourTable'[CostValue]),
CALCULATE(
SUM('YourTable'[CostValue]),
ALL('YourTable'[CostCategory])
)
)

If it is not working, do not hesistate to show with many countries what you are trying to achieve

Hi devdev,

Thank you for reaching out to the Microsoft Fabric Community Forum.

Create New measure

% of Grand Total = 
DIVIDE(
    SUM(CostTable[CostReceiving]),
    CALCULATE(SUM(CostTable[CostReceiving]), ALL(CostTable))
)

Format the measure

Select your new measure.

Navigate to Measure Tools > Format > Percentage.

Set it to display 2 decimal places, or adjust as needed.

Add the measure to the Matrix

Drag the % of Grand Total measure into the Values area of your Matrix.

This will instantly display both absolute values and percentages in separate lines for each region-category.

I have included the PBIX file that I created using the provided sample data. Kindly review it and confirm whether it aligns with your expectations.

If this solution worked for you, kindly mark it as Accept as Solution and feel free to give a Kudos, it would be much appreciated!

Thank you.

% of Grand Total = 
DIVIDE(
    SUM(CostTable[CostReceiving]),
    CALCULATE(SUM(CostTable[CostReceiving]), ALL(CostTable[Cost Sending]))
)

I hope I typed the column name corectly, you do not want to remove all filters

If it works, please give kudos and mark as a solution

Thanks

Hi devdev,

Has your issue been resolved?
If the response provided by FBergamaschi  addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

If yes, kindly accept the useful reply as a solution and give us Kudos. It would be appreciated.

Thank you for your understanding!