Propagating filters in EXCEL

DAX DAX Calculations
1

Hi @sam.mckay ,
I need to propagate filters between two tables that cannot have a relationship and I was about to use TREATAS, but I have to work in Excel where this function is not available.
Are there alternatives?

Thanks!

Roberto

2

@Roberto

Virtual Relationship INTERSECT =
CALCULATE (
    [Total Sales],
    INTERSECT (
        ALL ( Sales[Order Date] ),
        -- ^ Column on which the filters are to be applied
        VALUES ( Dates[Date] ) -- Column in the filter context
    )
)

.

Virtual Relationship CONTAINS =
CALCULATE (
    [Total Sales],
    FILTER (
        ALL ( Sales[Order Date] ),
        -- ^ Column on which the filters are to be applied
        CONTAINS (
            VALUES ( Dates[Date] ),
            -- ^ Column in the filter context
            Dates[Date], Sales[Order Date]
        )
    )
)
4 Likes
3

Hi @AntrikshSharma both worked nicely.
Thanks so much
Roberto

4

Hi @AntrikshSharma, did the response provided by @AntrikshSharma help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!