Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Creating a measure using two different column from different table

Hi There,   I am trying to create a calculated measure where i am taking difference from two columns(one is calculated measure and one is calculated column) which is avaiable in two different table...
Need Help
Show and Tell
Tips and Tricks
  • v-luwang-msft's avatar
    v-luwang-msft
    4 years ago

    Hi  Anonymous ,

    Refer the below:

    sumtablea = CALCULATE(SUM(TableA[value]),ALLEXCEPT(TableA,TableA[Product]))

    sunmtableb = calculate(SUM(TableB[value]),ALLEXCEPT(TableB,TableB[Product]))

    Relationship:

    Difference:

    Difference = [sumtablea]-LOOKUPVALUE(TableB[sunmtableb],TableB[Product],MAX(TableA[Product]))

    Outputresult:

    Did I answer your question? Mark my post as a solution!


    Best Regards

    Lucien

v-luwang-msft's avatar
v-luwang-msft
Community Support
4 years ago

Hi  Anonymous ,

Refer the below:

sumtablea = CALCULATE(SUM(TableA[value]),ALLEXCEPT(TableA,TableA[Product]))

sunmtableb = calculate(SUM(TableB[value]),ALLEXCEPT(TableB,TableB[Product]))

Relationship:

Difference:

Difference = [sumtablea]-LOOKUPVALUE(TableB[sunmtableb],TableB[Product],MAX(TableA[Product]))

Outputresult:

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Lucien,

     

    Thank you so much for your support. I tried and i got the result .

     

    I appreicate your help.

     

    Regards,

    Ashish