Forum Discussion
Wrong Totals
Dear Microsoft Community,
I'm struggling to find a solution for a simple calculation problem in POWER BI.
I want to multiply RealizedHours (Measure) with HourCost (decimal value for each resource from the data base).
Unfortunatley, I receive a wrong result, when I aggregate the product (sum):
However, I need the total costs for each resource and the total costs for my product ids at the end of the table.
Does anyone have an idea how I can fix this?
Thank you in advance,
BR
Alex
3 Replies
- PijushRoy
Community Champion
Hi alexKub
This article will help you https://learn.microsoft.com/en-us/dax/all-function-dax
If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS
Thanks
Pijush Hi alexKub ,
Could you please provide some raw data in your tables (exclude sensitive data) with Text format, the formula of measure [RealizedHours] and your expected result? It would be helpful to find out the solution. You can refer the following link to share the required info:
How to provide sample data in the Power BI Forum
And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
