Forum Discussion

CLNersesian's avatar
CLNersesian
Kudo Kingpin
10 years ago
Solved

DAX formula optimization question

Hello all,    I'm setting up some DAX measures to calculate the number of days late for delivered goods. The following formula is an example (I've expanded some of the terms to make it easier to un...
Need Help
  • Sean's avatar
    Sean
    10 years ago

    CLNersesian try without calculate

     

    Measure = COUNTROWS ( FILTER ('Sales Transaction', 'Sales Transaction'[Late Delivery 45 Days]="Days Late (45+)" ) )

kcantor's avatar
kcantor
Community Champion
10 years ago

How about simplifying and dropping the text reference?

Days Late (45+) = CALCULATE(COUNTROWS('Sales Transaction'), [Days Requested v. Ship Date] > 45)

Days Late (30) = CALCULATE(COUNTROWS('Sales Transaction'), [Days Requested v. Ship Date] > 30 && [Days Requested v. Ship Date] < 45)

 

 

I definately am no expert. I don't even play one on TV . . .

CLNersesian's avatar
CLNersesian
Kudo Kingpin
10 years ago

Thanks Kcantor - I get the same error message I mentioned above ("A function 'CALCULATE' has been used in a True/False expression taht is used as a table filter expression. This is not allowed.") using this formula. 

 

Ill play around with the filters and see if it's faster... more soon.