Greetings,
Iโm building an app for my BIL for his auto repair shop. What Iโm trying to do is filter a vehicle list based on the customer that selected.
Customers table has unique ID, Name and other relevant data
Vehicles table has unique ID, Owner (link to customer table), year, make, model and others
โJobโ table has a Ref to both of those tables ([Customer]
& [Vehicle]
).
I tried creating a slice that would run
ANY(Vehicles[Owner]) = [Customer])
I canโt get it to work thoughโฆIโm guessing there is a way to do it. I have something similar in another app that filters but it uses a dashboard and two separate tables to accomplish thatโฆI need to do it within the same form, if possible.
Solved! Go to Solution.
In Job[Vehicle] columnโs valid_if field, enter the expression:
FILTER( Vehicles , [Owner] = [_THISROW].[Customer] )
In Job[Vehicle] columnโs valid_if field, enter the expression:
FILTER( Vehicles , [Owner] = [_THISROW].[Customer] )
Thanks a bunch! Worked!
User | Count |
---|---|
41 | |
35 | |
27 | |
23 | |
16 |