Remove Content in Model Object Column Based on GUID Shared With Other Model Object

[Anonymous]

Hi all,

I am facing an issue where I need to remove rows in one model object based on a shared GUID listed in a column in another model object.

In this case, I have a list of successful leases that are linked to quotes for leases via this GUID. I need to remove the successful quotes from the quote model (or, at least, add a successful/unsuccessful column into that model) so that I can look at how our company is performing in certain markets. Otherwise I have a model that lumps all the successful/unsuccessful quotes together without disctinction and another model that is just the successful quotes, but no way to look at unsuccessful quotes by themselves.

In any advice?

[v-cherch-msft]

Hi @Anonymous 

It seems you may try to use LOOKUPVALUE like this post to get the successful quotes.Then if the column is blank,it is unsuccessful.If you need further help,please share a simplified data sample and expected output.

Regards,

[Anonymous]

That didn't work, I am getting an error message reading "a table of multiple values was supplied where a single value was expected."

Here's an example

Lease Table

QuoteID      

A

C

E

G

Quote Table

QuoteID

A

B

C

D

E

F

G

I need some way to either remove or mark ID's A, C, E, and G in the Quote Table.

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

You may create a measure like below and use it in visual level filter.

Measure = IF(MAX(Quote[QuoteID]) in VALUES(Lease[QuotelD]),1,BLANK())

Regards,