Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Creating Calculated column from Different table has a relationship but storage mode direct

I have Table A and Table B and both tables are joined using relationship, these tables storage mode set as Direct Query, is it possible to create a calculated with merging these tables/ or Is it poss...
Need Help
MattAllington's avatar
MattAllington
Community Champion
6 years ago

Why do you need a Calc column?  Power BI is designed to allow you to use data in different tables. 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I have Product & Sales in Table A and Product and Commission in Table B, and both these tables are joined using Product in the model. My Calcuclated column logic should be

 

Table A[Sales]*Table B[Commision] 

 

I tried using Lookupvalue and Related DAX fuction, throwing an error message. Since i am not sure what is the right approach, please advise.

 

I am using this in Direct Query mode and connected to Oracle database

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    What is the relationship between the two tables?

    Could you paste sample data or screenshots of two tables?

    You can also try the CROSSFILTER function

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.