Forum Discussion
Solved
ISINSCOPE Dax command help
I wrote this measure with the help of a forum user: YTD Budget = IF(OR(ISINSCOPE(Expenses[partner_name]),ISINSCOPE(Expenses[VendorJA])), BLANK(),CALCULATE(SUM(Budget[Amount]), MONTH(Budget[Me...
If you need to see how budgeting should be handled, you can go to this site: Budget – DAX Patterns
Looks promising thanks for your time and attention!
Be careful, though. I'd encourage you to read this: Many-to-many relationships in Power BI Desktop - Power BI | Microsoft Docs
You really need to fully understand the ramifications of what the document describes to know how to design/refine your model in order to always get correct figures.