How can I get the average GAP (last Column)

[Andrew_na_lang]

Hi Friends,

I have created a measure that shows the gap in hours between the (Earliest Sign up) 2nd column and (First order date)3rd column. I now need to know the average gap to visualize it as a card. Please help me. 

Measure used:

Gap from sign up to First Order (HOURS) = Datediff('Key Measures'[Earliest Sign up], [First Order Date], HOUR)

[moizsherwani]

@Andrew_na_lang Assuming you want to get an average per "full_name", you could use an AverageX function such as 

AverageSignup = AVERAGEX(values(full_name),[Gap from signup to First Order (Hours)])

[Andrew_na_lang]

@moizsherwani actually what I need is the average gap (Total) not the average sign up.

[johnt75 · Accepted solution]

Average gap = AVERAGEX( ADDCOLUMNS( VALUES( 'Table'[full_name]), "@val", [Gap measure]), [@val])

[Andrew_na_lang]

@johnt75 I don't need a new column. I just need the total average of gap from sign up to first order. 

[johnt75]

Its not a column, its a measure. Put this measure on a card visual and it will show the average gap

[Andrew_na_lang]

 Not working

[johnt75]

You need a close ) after the measure ], then delete the extra ) at the end of the line