Multiplying a measure in table A by a column value in table B

[taherelshafei]

I have three tables (Product, Product Movement, Product Factor).

Product Movement has a measure called "Total Product Out", Product Factor has a calculated column called "Product Factor".

What i need to do is to create a measure "Weighted Product Out", which equals Total Product Out * Product Factor (Of course each respective to the Product itself).

How can i achieve this?

[v-henryk-mstf]

Hi @taherelshafei ,

Directly passing the measure*calculated column method will cause calculation logic errors. We are unable to do further testing for you at the moment, and hope to provide testing data (delete sensitive information) and clear requirements.

How to Get Your Question Answered Quickly - Microsoft Power BI Community

Looking forward to your reply.

Best Regards,
Henry

[taherelshafei]

Thanks a lot for your help. 

Product table has an active one to many relationship with ProductMovement and ProductFactor (via ProductID).

I tried your suggestion, but RELATED wouldn't accept ProductFactor[ProductFactor], it doesn't even suggest any column. Not sure what i'm doing wrong.

[Pragati11]

HI @taherelshafei ,

Can you share some screenshots for your data model in Power BI please, along with the DAX you have written.

Please make sure your query has relevant details. refer the blog below: https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Thanks,

Pragati

[taherelshafei]

So here is the Model (table names are slightly different than the ones i used in the initial question, not to get confused).

Here is my calculated column on the ProductContraceptiveFactor Table:

Here is my initial measure

 

Here is a table to visualize the data:

 However, my approach failed, you can lool at the "Achieved Protection" total. 

[taherelshafei]

I just realized i missed the measure i created to transfer the Calculated Column to a measure.

 

[Pragati11]

HI @taherelshafei ,

What relationships have you got among these tables?

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

If there are appropriate relatioships in your tables, you can directly write a simple DAX calculation:

newCalc = [yourMeasure] * RELATED(yourTable[columnname])

Thanks,

Pragati