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

Sean's avatar
Sean
Community Champion
10 years ago

CLNersesian try without calculate

 

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

    • CLNersesian's avatar
      CLNersesian
      Kudo Kingpin
      10 years ago

      Thanks for the suggestions everyone. I was not able to use the forumla suggested by Sean because I do need to filter by a particular field. I think it's a performance issue that will needed be addressed at the service level. 

       

      Thanks again.