Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
I figured it out. Silly mistake. I forgot to set the cross filter direction to both
@Anonymous
You may simply try LOOKUPVALUE in DAX.
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.
I figured it out. Silly mistake. I forgot to set the cross filter direction to both
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |