Forum Discussion
Post Patronusing a measure to filter specific items
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.
Post PatronAnonymousThank you for your prompt response. I would like the ability to see all the account codes affiliated with Purchase orders 1,3 & 5 . currently your approach limits me to just viewing DEF & WXY. For example I would like the new table to like below
| Purchase Order | Account Code |
| 1 | ABC |
| 1 | DEF |
| 3 | DEF |
| 5 | PQR |
| 5 | STU |
| 5 | WXY |
dw700d I must be missing something, or just not following what you're trying to do.
Can't you just alter the code like below?FilterMeasure = IF( SELECTEDVALUE('Table (2)'[Purchase Order]) in {1, 3, 5}, 1 )