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

SabineOussi's avatar
SabineOussi
Skilled Sharer
10 years ago

I believe you don't need the second formula.

 

In order to get the count of how many shipments were late, you can put your Late Delivery 45 days field into a card visual and on the visual level filter, choose "Days Late (45+)".

CLNersesian's avatar
CLNersesian
Kudo Kingpin
10 years ago

Thanks Sabine - good thought, but I was actually going to use the formulas for other calculations. Also, the first formula, even in the card box is quite slow using Direct Query.