Forum Discussion
Total Row Miscalculation
Thanks for the attention to the problem from Ritaf1983.
Hi BuckedUpJJP ,
I don't have access to the link you provided, so I created simple test data:
The reason the total row is incorrect is that it adds up all the values and divides by 31, whereas there are not actually 31 days in every month. At this point we can create another measure:
Final Budget = SUMX(VALUES('dim_dates'[Month]),[Daily Budget])Result:
Best Regards,
ZhuIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi BuckedUpJJP
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
Here is my dataset for my Dim_Budgets table: https://drive.google.com/file/d/1K4mceCNQaLKBVnYuQp9CLBLC9nCXhQIq/view?usp=drive_link
Here is my dataset for my Dim_Dates table:
https://drive.google.com/file/d/1LF9-fqlCQfrcaVGKDT2qs0qSCXiXgpmf/view?usp=drive_link
Thanks for the attention to the problem from Ritaf1983.
Hi BuckedUpJJP ,
I don't have access to the link you provided, so I created simple test data:
The reason the total row is incorrect is that it adds up all the values and divides by 31, whereas there are not actually 31 days in every month. At this point we can create another measure:
Final Budget = SUMX(VALUES('dim_dates'[Month]),[Daily Budget])Result:
Best Regards,
ZhuIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your reply this worked to fix my issue!