Forum Discussion

AnSchmi's avatar
AnSchmi
Icon for Helper II rankHelper II
4 years ago

Filter table distinct items with multiple transaction types only

Dear BI Team,  for this demo and request I have created a simple model attached.  I would like to filter only items they are produced in production (transaction type = RM) and alternatively purcha...
Need Help
v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, AnSchmi ;

Looking at your source data, such as Item.No=1, the data is as follows:

According to the picture, the value of the <> "RM" is 6280; =RM' is 5000, which is consistent based on the results of your picture. and the [Vendor] is different.



So what do you want the output to be?


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 



 

 

  • AnSchmi's avatar
    AnSchmi
    Icon for Helper II rankHelper II
    4 years ago

    Dear v-yalanwu-msft, 

    the output should be filtered by items they have a "RM" transaction + any other transaction (RP + RO).
    items they have only RM transaction or no RM transaction should not be shown in the filter!
    I hope my explanation is clear now?

    Best Regards and have a nice day.