Difference between two Average Measure , but exclude if blank

[bcampbell]

I need to create a measure that I beleived to be simple , 

My measure currently is

AVGVAL_DISP-CALL = [AVG DISP]-[AVG CALL]

That does not work if where the AVG DISP measure has no timestamp in source and results in the CALL Timestamp value being the result and finally the AVG

Is there a way to write a measure that can ignore blanks ?

Do i need to go back to my  source measure that provides me the average ?

AVG CALL = CALCULATE(AVERAGE(frmain[Time]), FILTER(frmain,frmain[Time] <>0))

Thanks for any help

[Anonymous · Accepted solution]

Hi,

Can you try this.

AVG CALL = CALCULATE(AVERAGE(frmain[Time]), FILTER(frmain,NOT ISBLANK(frmain[Time])))

Regards,

Pavan Vanguri. 

[bcampbell]

I am still getting some errors when I intoduce a slicer

Looking at the selection ,

one record is missing a time for "DISP"

Do I need to adjust the next part of my measures ?

AVGVAL_DISP-CALL = [AVG DISP]-[AVG CALL]

[Anonymous]

Hi,

Can you please provide any example.

[bcampbell]

Thanks

I can provide the pbix if that be easier

TIME PBIX

[bcampbell]

Thank You !!

Worked well