Forum Discussion

stanislav_dugas's avatar
stanislav_dugas
Icon for Helper III rankHelper III
5 years ago
Solved

Sumx with Meassure

Hi Guys i need help with adjusting my sumxfunction.   I have 2 tables. 1st: Country Product APN UK A 20 UK B 10 US A 30 US B 10 2nd: Country Expenses UK...
  • VijayP's avatar
    5 years ago

    stanislav_dugas 

    While using an expression from other table , use RELATED Function. Try let me know that worked?

  • parry2k's avatar
    5 years ago

    stanislav_dugas solution attached, check measures in APN table, there are few more tables in the model, just ignore those.

     

    For this post, APN and Expenses are the relevant tables.

     

    Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.