Forum Discussion

aris's avatar
aris
Frequent Visitor
4 years ago
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/...
Need Help
  • bcdobbs's avatar
    bcdobbs
    4 years ago

    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.

bcdobbs's avatar
bcdobbs
Community Champion
4 years ago

Actually I think I'm doing it the opposite way round to what you want! Will update.

aris's avatar
aris
Frequent Visitor
4 years ago

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 

 

  • bcdobbs's avatar
    bcdobbs
    Community Champion
    4 years ago

    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