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

1 Reply

  • 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)