Transit Time Benchmark

[Anonymous]

Hi All,

I am trying to create a dashboard which compares actual Transit time against a benchmark transit time per lane. 

Actual Transit time from Kobe to Los Angeles, CA= 18 days

Benchmark Transit time Kobe to Los Angeles, CA= 15 days

Actual Transit time from Nansha to Seattle, WA= 25 Days

Benchmark Transit time Nansha to Seattle, WA=31 Days

Instead, my benchmark times are showing the same time for all of the ports. 

Benchmark Transit time Nansha to Seattle, WA=31 Days

Benchmark Transit time Nansha to Los Angeles, CA=31 Days

Benchmark Transit time Nansha to Long Beach, CA=31 Days

Benchmark Transit time Nansha to Chicago, IL=31 Days

It applying the average of all the ports collectively. My tables are linked based on a Origin&PortofArrival key. I have a table of all the actual data and another table of strictly benchmark data

[v-chuncz-msft]

@Anonymous 

You may simply try LOOKUPVALUE in DAX.

[Anonymous]

Hey so I tried that, but the relationship is not simply one to one. 

Many origins can go to one Port of arrival. Tokyo to LAX, Nansha to LAX, PASIR GUDANG to LAX, etc. Because of this, the LOOKUPLVALUE function will not work.

Below is a screenshot of what i have. 

[Anonymous · Accepted solution]

I figured it out. Silly mistake. I forgot to set the cross filter direction to both