How to sum up the custom revenue measure in DM
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
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):