Forum Discussion

bcampbell's avatar
bcampbell
Helper I
7 years ago
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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi,

     

    Can you try this.

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

     

    Regards,

    Pavan Vanguri. 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

 

Can you please provide any example.

bcampbell's avatar
bcampbell
Helper I
7 years ago

Thanks

 

I can provide the pbix if that be easier

 

TIME PBIX