Power BI - Formula Error

[Anonymous]

Hi,

We are getting unexpected result (always 0) when trying to multiplicate an integer value by a decimal value.
Our Power BI Desktop is connected through direct query to an AWS Redshift database.

The scenario looks like this:

We have two tables (Sales and Products)

SALES
Order ID	Product ID	Qtd Sales
1	1	2000
2	2	3000
3	2	4000
4	1	1000

Product
Product ID	Product Name	Price Per Unit
1	Milk	0,0735
2	Ice Cream	0,0531
3	Candies	0,0135

Sales and product are related by Product ID column.
Then we are trying to create a new column on that will be the result of multiplication beetwen Qtd Sales and Price Per Unit. The formula looks like this: Billing = Sales[Qtd Sales] * RELATED(Product[Price Per Unit])
One interesting thing about this problem is that when we change the connection from direct to import, everything works fine.

Any suggestion?

Tks all

[Anonymous]

Hi @Anonymous 

did you try  quick measure option to multiple both these fields?

Thnaks,

Tejaswi

[Anonymous]

Hi @Anonymous , 

Yes, I tried it.

It still returns zero for everything.

That sounds like a bug.

Tks