Forum Discussion
Helper ITotals of divde function
Super UserGerlofVisser , Somehow I am not able to find the sumx calculation
You need to
sumx(Values(Table[facility_id]), <Calculation>)
Helper IHi amitchandak ,
Thanks, that will help with my further queries, but you are right, this was no sumx issue.
I noticed there is also an error with summing up my "Total Potential", the actual sum of this column 84,771,290.7 (after export to excel).
Hi GerlofVisser ,
Please try to create a new measure and update the formula of measure [Total Potential boe] as below under the premise that the total value of measure [Total Gross Budget boe] is correct.
1. Create a new measure [Measure]
Measure =SUMX ( VALUES ( 'Facility_Lookup'[FACILITY_NAME] ), [Uptime Correction] )2. Update the formula of measure [Total Potential boe]
Total Potential boe =[Total Gross Budget boe] / [Measure]In addition, you can try the methods in the following links to handle it.
Measure Totals, The Final Word
Why Your Total Is Incorrect In Power BI
If all of them are not working, please provide some sample data and the correct values(exclude sensitive data) in form of table. It is better if you can provide your sample pbix file. Thank you.
Best Regards
Rena
- GerlofVisser
Hi Anonymous / amitchandak ,
Thanks for your thoughts.
I have mentioned to get the correct values, by using the calculatedtable dax.
Better Potential = sumx(CALCULATETABLE(flow_data_forecast,Rolling_Calendar[Year]),[Total Potential boe])And I have also adjusted the Total Potential measure:
Total Potential boe = [Total Gross Budget boe]/[Uptime Correction]Although I am not sure if this is the best approach, because it seems to take quite some computing power.
I was looking online on pros/cons for using this dax, but haven't really seen them yet. Do you have any advise?
Regards,
Gerlof