DAX measure slower when adding field from another table

[mahenkj2]

I have situation in which four tables namely A,B,C,D are connected this way:

I need to create a measure to calculate Overdue status, if [LatestDeliveryDate] in table D for each salesOrderItemID is high, equal or lower than today.

 May be as below:

OverdueMeasure = 
VAR LatestDeliveryDate = MAX(D[LatestDeliveryDate])
RETURN
IF(
    LatestDeliveryDate < TODAY(), 
    "Overdue", 
    "Not yet"
)

As soon as I add fields from table A with this measure, visual becomes slower and never see measure calculated in the visual. Without table A, it works fine. What changes I need to do in this measure, pls suggest.

[Sergii24]

Hi @mahenkj2, I believe there might be too many reasons for such behavior, so without semantic model and sample pbix it's gonna be difficult to give you a single advice that works.

From what I see in your model I suppose tables C and D (or at least one of them) to be dimensional table of SalesOrder. If so, my following question would be: how often you update your report? Once a day? If so, I'd define Overdue status in PowerQuery (considering that you check the date with today, even multiple refreshes on the day will not change this value). That will allow you to use this column  in other measures and even add it as a filter (as I expect one of your following tasks to be to "show" those orders in delay. So you can use this column as a filter instead of using measure on viasual level filters).

Let me know if it works for you and good luck!