Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Relationships and Lookupvalue - Calculated Measure, Not Column

Hi,   I have 2 different data source - one called DV360, the other called DCM.   The DV360 data is as follows:                 It has an ID and a row for each day with a Total Medi...
Need Help
Show and Tell
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi Anonymous ,

     

    Yes, you can create many to many relationship between DCM table and DV360 table based on ID , create relationship between DV360 table and Calendar table on the date field, then For all the relationships, try to change the Cross filter direction from Single to Both, which will treat the three tables as a single table, so you needn't create relationship between DCM table and Calendar table.

     

    You can create measure like DAX below to meet your demand.

     

    Measure1= CALCULATE ( FIRSTNONBLANK ( [Total Media value ], 1 ), FILTER ( DV360 , DV360 [CM Placement ID]= MAX(DCM [Placement ID])))

     

    Best Regards,

    Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

v-xicai's avatar
v-xicai
Community Support
7 years ago

Hi Anonymous ,

 

Yes, you can create many to many relationship between DCM table and DV360 table based on ID , create relationship between DV360 table and Calendar table on the date field, then For all the relationships, try to change the Cross filter direction from Single to Both, which will treat the three tables as a single table, so you needn't create relationship between DCM table and Calendar table.

 

You can create measure like DAX below to meet your demand.

 

Measure1= CALCULATE ( FIRSTNONBLANK ( [Total Media value ], 1 ), FILTER ( DV360 , DV360 [CM Placement ID]= MAX(DCM [Placement ID])))

 

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.