Forum Discussion
Multiplying 2 measures gives the wrong result
As you see in the image above, the [Total billed] column is the product of [total hours] * [Hourly Rate], the first result is fine, the second one, however, is very wrong, as 3,17 * 30 equals 95,10.
The full measure is:
Total billed = SUMX('back_office project_role_rate', [Total Hours in Jira]*[Hourly Rate])
I don't know why this happens, I tried converting to different data formats, changing rounding, chaging the DAX formula, adding like 10 decimal places, but the result is still wrong.
What could be the problem?
1 Reply
Anonymous try to convert data type in transformation tab.
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
