Forum Discussion
Filter per category
Have updated the demo file. The quanity measure needed to read the p/n currently needed...
Quantity = CALCULATE( SUM ( Stock[Qty] ), TREATAS( VALUES(Applicability[P/N]), Stock[P/N] ) )Could have made relationship bidirectional but this is safer.
Have updated the demo file. The quanity measure needed to read the p/n currently needed...
Quantity =
CALCULATE(
SUM ( Stock[Qty] ),
TREATAS( VALUES(Applicability[P/N]), Stock[P/N] )
)
Could have made relationship bidirectional but this is safer.
PERFECT!!! thank you so much bcdobbs! you are genious 🙂
Enjoyed it! Looked simple to start with but there are some subtle requirements! Thanks.
Pondering on your data model.
I think it's a legitimate use case of a bidirectional relationship. Especially if you only have those two tables. Would remove the need for the TREATAS.
hi bcdobbs
yes, birectional is the only available i can chose..
i havent used the Quantity measure and it adds up correctly.
The next challenge, how could i filter if i want by A/C type that is unique : ex. 787 only.
so in my initial example, by chosing 787 it would normally show only D; A would be excluded as its both 787 and 737.
I think the easiest to solve this is by using filter "does not include" in applicable types ? 😊
Rgds
Aris