Calculate a Measure based on a referenced column from another column in same table

[mvelasquez1970]

Hi,
I've been trying to figure out how to approach this situation. I have a table like the one here:

I need a measure (Measure) that calculates the sum of TD based on the MidPoint Column refereferenced by EndPoint Column. So, if I choose EndPoint = Point A it sould return 8 as the sum of 4+3+1 where Midpoint = EndPoint = Point A. The problem is that when I select (filter) EndPoint = Point A, it filters out the rows where MidPoint = Point A, so what I get is 0.

Please help with this.
@amitchandak @Ashish_Mathur @Rayshin 

Thank you!

[Ashish_Mathur]

Hi,

In the Query Editor, select te last 2 columns, right click and select Unpivot Other columns.  Create a slicer of Attribute and select Midpoint.  Create another slicer of Value and select Point A.  Write this measure

Measure = sum(Data[TD])

Hope this helps.

[amitchandak]

@mvelasquez1970 , Try a measure like

calculate(sum(Table[TD]), filter(allselected(Table), Table[Mid Point] = max(Table[end Point]) ) )

[mvelasquez1970]

Thanks,
It partially works. When I use a table it shows the correct result for each EndPoint. However, when I select an EndPoint from a slicer it returns 0...