INTERSECT over 2 CALCULATED Tables

[Anonymous]

As a newbie I am stuck on this one for hours now not knowing why it won't work. I am trying to create a new column like below, but I get an error:  The expression contains multiple columns, but only a single column can be used in a True/False expression that is used as a table filter expression. Can someone tell me where do I have multiple columns?

Expired =
VAR __ProposedIds = SELECTCOLUMNS(CALCULATETABLE(
ReportData,
ReportData[Event] = "Proposed" && ReportData[Consumer.CompanyGuid] = Consumer[CompanyGuid]
), "Ids", [LeadId])
VAR __ExpiredIds = SELECTCOLUMNS(CALCULATETABLE(
ReportData,
ReportData[Event] = "Expired"
), "Ids", [LeadId])

RETURN COUNTROWS( INTERSECT(__ProposedIds, __ExpiredIds)) + 0

I have a table ReportData with many Columns (Event, CompanyGuid etc..) I have another table Consumer where I am creating additional columns. What I want is a count of Expired events from ReportData table. That is for a given LeadId if there exists an Event Expired and also an Event Proposed with Conusmer.CompayGuid being that of Consumer table CompanyGuid. 

[V-pazhen-msft]

@Anonymous 
I not sure why you used Selectedcolumns, It seems you wanted to [leadid] in addition to the var tables. But it looks like the LeadId is already in the report data table. Try your dax without selectedcolumns.

Expired =
VAR __ProposedIds=CALCULATETABLE(ReportData,ReportData[Event] = "Proposed" && ReportData[Consumer.CompanyGuid] = Consumer[CompanyGuid])
VAR __ExpiredIds=CALCULATETABLE(ReportData,ReportData[Event] = "Expired")

RETURN COUNTROWS( INTERSECT(__ProposedIds, __ExpiredIds)) + 0

 Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@Anonymous what is the relationship between ReportData with Consumer table and the issue is with this expression

&& ReportData[Consumer.CompanyGuid] = Consumer[CompanyGuid]

Not sure why you are doing this. I would recommend to share some sample data and expected output.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[Anonymous]

@parry2k 

Yes the issue seems to be there, because if I remove the AND condition then I get 0 as my value. ReportData is a new table which is the result of a LEFT JOIN of another table and Consumer table. Now I am extending the Consumer table with new columns. Any tips?