Dax Formula

[Jedahn]

Hello PowerBI Community,

So I have two datasource in excel. First is the "Target" table which contains the names of the customers that the employees need to call. Second is the "Actual" table that contains all calls made by the employees to their customers. I want to know is if they called their target customers it will return a unique count as 1, if not then 0. 
I'm using this excel function when I want to have a result mentioned above.
=IFERROR(XLOOKUP(C2,'Target Table'!G:G,'Target Table'!I:I),0)

Thank you very much,

[BrianConnelly]

I would probably start with the lookup function and add rules as needed...

LOOKUPVALUE(
    <result_columnName>,
    <search_columnName>,
    <search_value>
    [, <search2_columnName>, <search2_value>]…
    [, <alternateResult>]
)

[FreemanZ]

hi @Jedahn 

please provide your sample data tables, it is easier for all. 

[Jedahn]

Hello. I was trying to but i can't find it. Where can i find the attach file button?

[FreemanZ]

hi @Jedahn 

Unfortunately, there is no such button. Check this:

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...