Calculate Amount of Time Greater than Constant Line Y Value

[Bebo]

I would like to calculate the amount of time (my x value) is grater than a specified constant line Y value.

Any ideas would be greatly appreciated.

[amitchandak · Accepted solution]

@Bebo , Assume you have measure M1 and constant line Measure

Say M2 =10 //just any number 

Assume column on x axis is col

Try a new measure 

sumx(Values(Table[Col]), If([M1] >[M2], [M1], Blank())

[Bebo]

Thank you!