How to sum up the custom revenue measure in DM

Summary:

I have requirement to sum up the custom revenue measure yearly for all the category and calculate the percentage of revenue for each category based on it.

% category revenue = individual category revenue/Total revenue of all categories*100

i tried summing up the total revenue of all categories using Moving_Total expression but it returns only value for individual categories and not the Total

Is there way we can use the summary from table to calculate

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):