Forum Discussion
Solved
Difference between two Average Measure , but exclude if blank
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 ...
Hi,
Can you try this.
AVG CALL = CALCULATE(AVERAGE(frmain[Time]), FILTER(frmain,NOT ISBLANK(frmain[Time])))
Regards,
Pavan Vanguri.
Hi,
Can you try this.
AVG CALL = CALCULATE(AVERAGE(frmain[Time]), FILTER(frmain,NOT ISBLANK(frmain[Time])))
Regards,
Pavan Vanguri.
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]