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+)" ) )

MattAllington's avatar
MattAllington
Community Champion
10 years ago

How big is your transaction table?

 

Why are you using ALL(Sales Transaction) ?   This will slow the whole thing down - unless you have a reason for using ALL, just use the table instead

CLNersesian's avatar
CLNersesian
Kudo Kingpin
10 years ago

Hi MAllnington,

When I remove the ALL() function I get the error I mentioned in other posts about True/False expression. Adding the ALL() and FILTER() functions cleared the existing filter and I was able to get past the error message.

 

Do you know an alterntive way to write the formula that avoid ALL() and FILTER() because I know the row level filtering is slow. I just can't figure out how to write the formula without it.

Thanks,

C.