Multiplication of measure and column give incorrect result

[jatneerjat]

Hi,

I have created a calculated column by multiplying a measure and a column as below

but when i drag this column in power bi then it gives me wrong result as below:

here i multiply A and B,the result is C

What could be the reason?

[Anonymous · Accepted solution]

@jatneerjat,

Please share sample data of your table so that we can test.

I make a test in my own sample table and create the column below.

Column = CALCULATE(SUM(Table3[Price])*[Measure],FILTER(Table3,Table3[Type]=EARLIER(Table3[Type])))

By the way, why not directly create a measure?

Regards,
Lydia

[jatneerjat]

Thanks @Anonymous,I did create a measure directly and it works.