Forum Discussion
Calculated table/vlookup
I am struggling with the following: I have one table (1) with deal ID's and data about related activities (one deal ID can have multiple activity IDs). I have another table (2) with deal IDs and da...
Laila92You could probably create a relationship between the two tables, that might make this easier.
Sorry I should have mentioned this but there is a relationship between Activity ID and the activity ID in the deals table, i will edit the question
Laila92So it looks like you want to pick deals that were won (plus additional selection criteria) which have an activity of type demo.
lookupvalue will not work since it could return multiple values. One option is to add a relationship between the deal ids (it will be inactive) and then create a count measure that counts the number of activities for the deal with type demo, you will need to use Userelationship for this.