0

I have [scan Time] column and [Location] column which have different locations like Security T2, Post security T2 DOM , Post Security T2 INT.

So want to subtract Scan Time of Post security T2 DOM and Security T2 also Post security T2 INT and Security T2

So i have tried to make measure like this

Post_Security_T2_DOM - Security_T2 = var Security_T2 = CALCULATE(AVERAGEX( FILTER(EGateData, EGateData[Location] = "Security-T2"), (EGateData[Scan_Time])))

var Post_Security_T2_DOM = CALCULATE(AVERAGEX( FILTER(EGateData, EGateData[Location] = "Post Security T2 DOM"), (EGateData[Scan_Time])))

var Total_Time = CALCULATE(Post_Security_T2_DOM - Security_T2)

return FORMAT(Total_Time,"HH:MM:SS")

0 Answers0