Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Transit Time Benchmark

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

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

3 REPLIES 3
v-chuncz-msft
Community Support
Community Support

@Anonymous 

 

You may simply try LOOKUPVALUE in DAX.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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. 

TT powerbi.JPG

 

Anonymous
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.