Why so Slow?

[pjmorris]

I have the following measure:

=CALCULATE(DISTINCTCOUNT(qryVault[Doc No]), qryDDM,
           qryVault[Issued Date]>0,
           FILTER(qryVault,qryVault[Issued Date]<=[PeriodEndDate])
    )

Which causes 'RefreshAll' to take over 15 minutes.

Change it to:

=CALCULATE(DISTINCTCOUNT(qryVault[Doc No]), qryDDM,
           qryVault[Issued Date]>0
    )

And it only takes 40 seconds or so.

The measure [PeriodEndDate] is defined as:

=CALCULATE(max(qryCalendar[Date]),ALLSELECTED(qryCalendar))

Any ideas gratefully received.

Regards

Peter

 

[pjmorris]

PS. The measure referred to above is named [CountAllIssued] and is used subsequently in this measure:

=CALCULATE([CountAllIssued], 

     FILTER(qryvault, (qryVault[Date Comments Returned]>[EndDate] || qryVault[Date Comments Returned]=0)
             )
     )