Problem with Quick Measure and Multiplication

[DRASS_PBI]

Hello everybody,

I've recently started learning how PBI works, I've been left with the (great) work of the colleague who created all our reports.

I have a report that shows how many items are available in the warehouse.

It takes the some of the data from a source, like the number of the items and their Part Number, and from another source it takes the price of every PN.

At the end I need to have a new column which shows the total price of each PN.

Example, I have 456 Units of PN XXXXXX which costs 0,34€ each, so the new column should show as result 155,04.

The same for every other PN.

When I try to set a "Quick Measure", select the operation, the columns that i want to multiply, it gives me completely wrong values.

This is the resulting formula

What am I doing wrong ?

Thanks for any advice !

Best Regards !

edit: typo

[DRASS_PBI]

Just to add some informations:

This are the tables from which I retrieve the data

PN	Data	PN-DATA	COSTO/CAD	VALUTA
011698-6_0100	10/13/2020 12:00 AM	0011698-6_0100-13/10/2020 00:00:00	41	EUR
011698-7_0000	10/13/2020 12:00 AM	0011698-7_0000-13/10/2020 00:00:00	27	EUR
012142-A_0200	10/17/2018 12:00:00 AM	012142-A_0200-17/10/2018 00:00:00	175	EUR

And this is the other table, with the PN (ITMREF_0) and the count of how many PNs we can find in the warehouse.

ITMREF_0	Count
0011698-6_0100	6
011698-7_0000	6
012142-A_0200	1

This table had more values with the same ITMREF_0 (PN), so I used the "Group By" function to have each ITMREF_0 and the total count.

Hope this helps.