Sum of Matrix table column Total

[NewbieJono]

i have a ratio to days old calculation 

Ratio Day's Old = [Working Days Old] * [% Of Volume Grand Total]

but on the bottom of my table it is not totalling the ratio's it is producing the answer 7. it should be approx 3.2

is there anyway i can just get a total of the Ratio Day's Old Coloumn, as a separate measure woudl be good

[Anonymous]

Hi @NewbieJono ,

In addition to Mikelytics's reply, I suggest you to try SUMX() based on [Ratio Day's Old] measure, if his code doesn't work.

Ratio Day's Old = 
SUMX(
   'Table'[Column which defines the granualrity of your visual],
   [Ratio Day's Old]
)

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mikelytics · Accepted solution]

Hi @NewbieJono ,

Please try the following measure:

Ratio Day's Old = 
SUMX(
   'Table'[Column which defines the granualrity of your visual],
   [Working Days Old] * [% Of Volume Grand Total]
)

If you would post the whole cisual I could give you a more detaile answer but by in the end the function is what you are looking for when you replace 'Table'[Column which defines the granualrity of your visual] with the right values.

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

[Greg_Deckler]

@NewbieJono First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8