Forum Discussion
Helper IIISumx with Meassure
While using an expression from other table , use RELATED Function. Try let me know that worked?
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.⚡
Community ChampionWhile using an expression from other table , use RELATED Function. Try let me know that worked?
stanislav_dugasPerfect this solved my problem Related function brought the expenses into my main table and then i was able to quickly calculate it 🙂 thx alot