Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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
@adam_mac , what is the formula for run rate?
Hope you have used Average(Default Summarization)
or a measure like Average(Table[Run Rate])
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |