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 a go with this demo: Applicability Demo
Rather than dropping the A/C column into the visual use this measure instead (and use P/N from your stock table):
Applicable Types =
VAR Result =
CONCATENATEX(
VALUES(Applicability[AC type]),
Applicability[AC type],
", ",
Applicability[AC type], ASC
)
RETURN IF ( ISINSCOPE(Stock[P/N]), Result, BLANK() )
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.
that looks very promising!! not sure if it would be possible for ex. that only selected AC types are shown in the table.. i selected 787 and total q-ty is 67. if non relevant where hidden then it would be perfect
I think my change to the quanity measure mentioned below does what you need.
Hoping latest version has now synced up to cloud! Give it a minute and download a fresh copy from Applicability Demo
