Forum Discussion
Matrix values help
Anonymous ,Refer if this can help
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
Anonymous got it, use ISINSCOPE function to control where you want to show the budget amount, here is the post that talks about it in detail.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
You'd either need to:
a) make some sort of relationship between your tables so that $62k is distributed between the order lines
b) create a measure that returns a blank when something is filtered by an order line but returns the result when it doesn't
Thank you... I'll go with the measure. I couldn't figure out how to go about writing that measure but it is really clear the way you put it. Thanks