How to find the value of X-axis where the line graph intercepts the x axis (y=0)

[Anonymous]

Hi all,

Is there a way to do this via Dax Measures? 

[amitchandak · Accepted solution]

@Anonymous , Assume you are looking for [Return on Investment]  to be 0 on axis , else give a range

Measure  =

maxx(Filter( values(Table[Day]) ,[Return on Investment] =0), [Day])