DAX for percentage values

[devdev]

I need percentage values as described in the table in the right side

For example : 

High -cost is showing 51%. This we are getting when we divide 171,915,156 / 335,631,725 

Similarly Medium-cost is showing 2% . This we are getting 7,920,658 / 335,631,725

How is this achievable using DAX?

[v-sgandrathi]

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!

[FBergamaschi]

% 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

[FBergamaschi]

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

Sorry I had forgotten another filter to remove

If it works, please give kudos and mark as a solution, if it does not please specify all the columns that are grouped in Filters, Rows and columns section of the pivot table

Thanks

[devdev]

@FBergamaschi , This doesnt work as well

[v-sgandrathi]

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.

[devdev]

Hi @v-sgandrathi , I am getting this error

The cost receiving column has text values 

[Cookistador]

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

[devdev]

Hi @Cookistador , THis is not giving correct result
More examples for you below:

For Europe region:  501,679,459 / 752,307,107 gives 67%