cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
adam_mac
Helper I
Helper I

DAX Function to show same figure in the grand total

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?

 

adam_mac_1-1613488151371.png

 

3 REPLIES 3
veenashenolikar
Helper V
Helper V

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

amitchandak
Super User IV
Super User IV

@adam_mac , what is the formula for run rate?

 

Hope you have used Average(Default Summarization)

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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.

Capture.PNG

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors