DAX Function to show same figure in the grand total

[adam_mac]

Hi, i am multiplying the run rate by the working days to give me my target which works fine until i get to the total. 

I have used a SUM function to give me my RunRate column which is obviously not correct. What function or formula should i use so that the RunRate total will also equal 10.24 instead of 102.36?

[amitchandak]

@adam_mac , what is the formula for run rate?

Hope you have used Average(Default Summarization)

or a measure like Average(Table[Run Rate])

[adam_mac]

hi @amitchandak , the formula i have used for RunRate is RunRate = SUM(DailyRunRates[DailyRunRate])  which i know is incorrect (at grand total level anyway, at individual day level, the 10.24 is correct). 

I tried the average function also however this just produces incorrect results.

[veenashenolikar]

Hi @adam_mac 

Try creating a measure rather than a column for the  "RunRate = SUM(DailyRunRates[DailyRunRate])" calculation

If this helped resolve your issue please mark my reply as a solution.

Regards,

Veena Shenolikar