Trying to Determine Average Days Late or Early for Deliveries

[Canknucklehead]

I am trying to create a visual that will show the average number of days that a given part is delivered early or late. Here is a sample of the table data:

I have measures to calculate the number of On Time, Early or Late deliveries:

Number of Early =
CALCULATE(
COUNTROWS('Fact PO Details'),
FILTER(
ALL('Fact PO Details'[Days Early or Late]),
'Fact PO Details'[Days Early or Late] = "Early"))

The measures, however, will not return any results in a visual. Searching around, I find information that indicates I need to include a Date Limit measure in my Date table and use that for some of the measures. However, when I try to create the Date Limit measure, I keep getting this error:

The Date Table does have a Date Column. I've tried creating the Date Table with a very limited range - 2019-2022, but 

Any ideas as to where I am going wrong?

[fhill]

Does this work instead?  You may have over narrowed the filter to a specific column, instead of just using the Table Name in ALL?)

Number of Early =
CALCULATE(
COUNTROWS('Fact PO Details'),
FILTER(
ALL('Fact PO Details'),
'Fact PO Details'[Days Early or Late] = "Early"))

[Canknucklehead]

Unfortunately, no, that doesn't fix the issue. 

[v-easonf-msft]

Hi, @Canknucklehead 

Please recheck your field name:

Number of Early = 
CALCULATE (
    COUNTROWS ( 'Fact PO Details' ),
    FILTER ( ALL ( 'Fact PO Details' ), 'Fact PO Details'[Late or Early] = "Early" )
)

If it doesn't work, please share your sample file for further research.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Canknucklehead]

That has partially resolved the issue. I have two different fields for Early and Late and was referencing the wrong one. 

The Date Limit measure still won't work in the Date Dimension. Same error as above in the original post. And the Number of Early measure does not interact with any Date Slicer. I am going to keep trying.

[v-easonf-msft]

Hi, @Canknucklehead 

Could you please tell me whether your problem has been solved ? For now, there is no content of description in the thread.

If yes, you could accept the helpful answer as solution to close this thread. You could also share your own solution here.More people will learn new things here.

If you still need help, please feel free to ask and share more details.

Best Regards,
Community Support Team _ Eason