Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

If Condition with Many to Many Relationship

Hi all, am looking to accomplish the below scenario please provide your suggestions.  
Need Help
mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hi Anonymous 

 

try this.

DistinctCount ProductID = 
    VAR fTable = FILTER(Table1, Table1[Actual Date] <> BLANK() && Table1[Actual Date] in VALUES(Table2[Date]))
    VAR dTable = DISTINCT(SELECTCOLUMNS(fTable, "Product ID", [Product ID]))
RETURN
    COUNTROWS(dTable)