Forum Discussion

charleshale's avatar
charleshale
Icon for Continued Contributor rankContinued Contributor
2 years ago

Data Lineage Failing to Change with Virtual Table and TREATAS

Can anyone see why the following fails to change the data lineage from dimdate[date] to bookings[agreement end date]?

Book AvailToRenew= 
VAR _MyTable =  
      ADDCOLUMNS ( 
        SUMMARIZE('Bookings', 'Bookings'[Deal ID]),
        "@ATR",  sum('Bookings'[Contract Value]) 

VAR _Dates = VALUES('Bookings'[agreement end date]) 

RETURN
CALCULATE(
    SUMX(_MyTable, [@ATR]), 
    TREATAS(_Dates, DimDate[Date])
)

 

2 notes

(1) if I make the TREATAS in a separate measure, the date shift holds. Ther must be something in the virtual table where I'm failing to shift the lineage.
(2) I am having the same issue on similar constructs as the above using USERELATIONSHIP and a physical table relationship.

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    2 years ago

    charleshale , In this case date table should not be joined with any date of your table

     

    example

    CALCULATE(
    sum('Bookings'[Contract Value]),
    TREATAS(VALUES('Bookings'[agreement end date])
    , DimDate[Date])
    )

     

     

    In case of multiple relationship

    CALCULATE(
    sum('Bookings'[Contract Value]),
    UseRelationship([agreement end date], DimDate[Date])
    )

     

    Not sure on role of id in this case, As it is sum