Forum Discussion
Solved
Filter per category
Hi ! I have 2 tables, Table A shows part number applicability , Table B shows stock levels. I want to create a report that shows P/N and q-ty per selected AC type. I tried (snip below) but i get P/...
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.
Actually I think I'm doing it the opposite way round to what you want! Will update.
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 🙂
