Multiplying 2 measures gives the wrong result

[Anonymous]

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?

[fahadqadir3]

@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.