Switch date table using virtual relationship

Question

Hi all,&nbsp;I have a measure called [no of deliveries] which I normally use with my date table &nbsp;‘Dim-OutboundDate’&nbsp;I need to use this measure with my other date table ‘Dim-Date’, and the outcome should be the same.&nbsp;No matter what I try though, the outcome is different when I group it by week in the visual.&nbsp;This is the new measure I’m trying to create:&nbsp;CALCULATE(&nbsp;&nbsp;&nbsp; [no of deliveries],&nbsp;&nbsp;&nbsp; TREATAS(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VALUES(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'Dim - Date'[ID_Date]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ‘Dim-OutboundDate’ [ID_Date]&nbsp;&nbsp;&nbsp; ))&nbsp;Below is my data model (one to many) and I am restricted to do any physical changes with the relationships, so I need to solve this with a measure.&nbsp;&nbsp;&nbsp;Many thanks!

johnt75 · Accepted Answer

Try
My Measure =
CALCULATE (
    [no of deliveries],
    TREATAS ( VALUES ( 'Dim - Date'[ID_Date] ), 'Dim-OutboundDate'[ID_Date] ),
    REMOVEFILTERS ( 'Dim - Date' )
)

Forum Discussion

Switch date table using virtual relationship

2 Replies

Related content

Relationship

Fabric virtual table

Relationships

USE Relationship with Switch

Relationship Issue