Forum Discussion

dw700d's avatar
dw700d
Post Patron
5 years ago
Solved

using a measure to filter specific items

I have a table with multiple purchase orders .Each purchase order has multiple account codes. I would like to create a measure that only shows purchase orders that contain specific account codes. For...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi dw700d ,

     

    Do you have a special purchase order list that you want to filter? The table is like

    Create the relationship as follows

     

    The filtered table is as follows. Account Code is from the main table and Purchase Order is from another table. Set the value of the purchase order in the filter is not blank.

     

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

     

dw700d's avatar
dw700d
Post Patron
5 years ago

Anonymous  sorry I read you answer wrong. I see now that your approach would work. My challenge is I have over 1,000 purchase orders so putting each individual number in the measure would be difficult

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi dw700d ,

 

Do you have a special purchase order list that you want to filter? The table is like

Create the relationship as follows

 

The filtered table is as follows. Account Code is from the main table and Purchase Order is from another table. Set the value of the purchase order in the filter is not blank.

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.