Forum Discussion

SteveODea's avatar
SteveODea
Icon for Helper I rankHelper I
6 years ago
Solved

Calculating Averages from Data Across Different Tables

I have a data structure which is causing me some problems in the calculating of a couple of measures...   I have 2 fact tables: Applications with a Submitted Date Status Table with Offer & Accep...
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    Please try this measure:

    AverageDecisionTurnaround5Days = CALCULATE(AVERAGEX(FILTER(ALLSELECTED('Status'),'Status'[Status]="Offer" && 'Status'[StatusDate] >= MAX('Dates'[Date])-30 && 'Status'[StatusDate] < MAX(Dates[Date])),'Status'[Turnaround]))

    And it shows:

    Hope this helps.

     

    Best Regards,

    Giotto Zhi

     

v-gizhi-msft's avatar
v-gizhi-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi,

 

Please try this measure:

AverageDecisionTurnaround5Days = CALCULATE(AVERAGEX(FILTER(ALLSELECTED('Status'),'Status'[Status]="Offer" && 'Status'[StatusDate] >= MAX('Dates'[Date])-30 && 'Status'[StatusDate] < MAX(Dates[Date])),'Status'[Turnaround]))

And it shows:

Hope this helps.

 

Best Regards,

Giotto Zhi