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

Anonymous's avatar
Anonymous
Not applicable
10 years ago

While for the second formula you can use this measure:

 

 

Let me know if it works for you.

 

#I'M Not An Expert#

CLNersesian's avatar
CLNersesian
Kudo Kingpin
10 years ago

Thanks for the suggetion B129, I originally tried that formula but kept getting an error: "A function 'CALCULATE' has been used in a True/False expression taht is used as a table filter expression. This is not allowed." 

 

This error lead me to adapting the formula as you saw. I think the error is related to how filter interactions relate in PBI - because it works fine in Excel.