Calculate Transit time between port destination

Question

Hi all,&nbsp;I have table with the following data:&nbsp;Index - running number - no special purposeLineDirection - the line route namePort - one of the route directionTransitTime - the time take to go from one port to the one ofter&nbsp; - e.g. GRPIR to ILASH - 3 daysCumulativeTT - the cummulative time between different port - e.g. TRIST to ILASH - 7 days&nbsp;I want the user to choose 3port e.g. ILASH and BRSSZ and SGSIN and the PBI should show 56 (32+24),ILASH to SGSIN&nbsp; = 32 - 0 = 32SGSIN to BRSSZ = 33 - 9 = 24&nbsp;the transhipment happen in SGSING&nbsp;what is the right dax measure for this case?hope I was clear.thanks in advaced !!!&nbsp;IndexLineDirectionPortTransitTimeCumulativeTT1MD3_EILASH002MD3_EGRPIR333MD3_ETRIST474MD3_ETRALI3105MD3_ETRMER3136MD3_EEGSUZ2157MD3_ESAJED3188MD3_ESGSIN14329MD3_ETWKHH53710MD3_EKRPUS44111MD3_ECNSHA24312MD3_ECNNGB24513MD3_ECNYTN24714SA3_WCNSHA0015SA3_WCNNGB1116SA3_WCNYTN3417SA3_WHKHKG1518SA3_WSGSIN4919SA3_WBRIGI233220SA3_WBRSSZ13321SA3_WBRPNG13422SA3_WBRNVT23623SA3_WUYMVD33924SA3_WARBUE44325SA3_WBRRIG245

nirrobi · Accepted Answer

Thanks for your recommendation,&nbsp;I was able to solved the problem using the following DAX formula:&nbsp;Cumulative TT=CALCULATE(&nbsp;&nbsp;&nbsp; SUM( Table1[CummulativeTT] ) ,&nbsp;&nbsp;&nbsp; FILTER(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALL( Table1 ) ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Table1[Index] &lt;= MAX( Table1[Index] )&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &amp;&amp; Table1[LineDirection] = MAX( Table1[LineDirection] )&nbsp;&nbsp;&nbsp; ))&nbsp;The *MAGIC* for me wat the last line - where I can compare TEXT with the MAX function.&nbsp;&nbsp;

Forum Discussion

Calculate Transit time between port destination

2 Replies

Related content

Context Transition in DAX

SQL Operator with multiple destinations

Different schema into different destination

DataFlows Data Destination

Dataflow - Destination Issue

Index	LineDirection	Port	TransitTime	CumulativeTT
1	MD3_E	ILASH	0	0
2	MD3_E	GRPIR	3	3
3	MD3_E	TRIST	4	7
4	MD3_E	TRALI	3	10
5	MD3_E	TRMER	3	13
6	MD3_E	EGSUZ	2	15
7	MD3_E	SAJED	3	18
8	MD3_E	SGSIN	14	32
9	MD3_E	TWKHH	5	37
10	MD3_E	KRPUS	4	41
11	MD3_E	CNSHA	2	43
12	MD3_E	CNNGB	2	45
13	MD3_E	CNYTN	2	47
14	SA3_W	CNSHA	0	0
15	SA3_W	CNNGB	1	1
16	SA3_W	CNYTN	3	4
17	SA3_W	HKHKG	1	5
18	SA3_W	SGSIN	4	9
19	SA3_W	BRIGI	23	32
20	SA3_W	BRSSZ	1	33
21	SA3_W	BRPNG	1	34
22	SA3_W	BRNVT	2	36
23	SA3_W	UYMVD	3	39
24	SA3_W	ARBUE	4	43
25	SA3_W	BRRIG	2	45