Forum Discussion
INTERSECT over 2 CALCULATED Tables
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 ...
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.