Forum Discussion
return values from Intersect
Hi I'm trying to get the LeadID that intersects two tables I created this measure: Measure =
VAR _StartDate =
CALCULATE (
MIN ( FactMarketingFunnel[StartDate] ),
ALL ( F...
ReutAtias12 , Assume you have a common table lead with lead ID and measure from 2 tables joined to it say M1 and M2
then intersect is
countx(values(Lead[Lead ID]), if(not(isblank([M1])) && not(isblank([M2])) , [Lead ID], blank()) )
Hi,
M1 and M2 are virtual tables that I'm creating in the measure
They are supposed to be dynamic base on the user filters for the stage field