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

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. 

aris's avatar
aris
Frequent Visitor
4 years ago

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