Forum Discussion
Gwhiz
Helper I
Helper IPulling values off an inactive relationship
I am trying to pull the value of a parent account number which has an inactive relationship to another table that contains all account numbers and a qty column. The child account number has the a...
GwhizHelper I
Helper IThanks for replying v-juanli-msft however your method doesn't solve the main problem of getting the parent accounts Qty value to show only when the child account number is chosen.
The reason for this is to quickly compare the Qty from the Parent account to the child account in a big dataset. And each day 10-30 child accounts will be filtered for and having this formula will automate that comparison.
Is this even possible with DAX?
GwhizHelper I
Helper II think the only solution to this is to perform a join on the two tables