Basket Matrix variend based on timeline/filter selection

[jak82]

Hi,

I am using a basket case matrix to check cross sells against a product.

Using

=CALCULATE (
    DISTINCTCOUNT ( AdDetails[company] ),
    CALCULATETABLE (
        SUMMARIZE ( AdDetails, Table2[Company Grouping]),
        ALL ( titles ),
        USERELATIONSHIP ( AdDetails[ttlname],'FilterTitle'[filterttlname] )
    )
)

Now I am wanting to check variance (last year) either based on a cell range or a timeline selection. probably n a where statement.


Any ideas.... Thanks

 

[jak82]

Following some digging I have tried

=CALCULATE (
    DISTINCTCOUNT ( AdDetails[company] ),
    CALCULATETABLE (
        SUMMARIZE ( AdDetails, Table2[Company Grouping]),
        ALL ( titles ),
        USERELATIONSHIP ( AdDetails[ttlname],'FilterTitle'[filterttlname] ),SAMEPERIODLASTYEAR('Calendar'[Date])
    )

- But it is still bringing up the same values as if the same period was not there.

 

[jak82]

Any ideas?