Count all function not influenced by date

Hi Anonymous,

You could have a try with the formula below.

Total_Lines_Backlog =
CALCULATE (
    COUNT ( PD_vs_shipped_date[Item_Number] ),
    FILTER (
        ALL ( PD_vs_shipped_date ),
        PD_vs_shipped_date[OTD_category] = "Backlog"
    )
)

If you still need help, please share some data sample and your desired output so that we can help further investigate on it?

Best Regards,

Cherry

Hi,

Try this measure

=CALCULATE(COUNT(PD_vs_shipped_date[Item_Number]),PD_vs_shipped_date[OTD_category] = "Backlog",ALL(Calendar))

I have assumed that:

1. There is a Calendar Table
2. There is a relationship from the Date column of your PD_vs_shipped_date Table to the Date column of your Calendar Table
3. In the Calendar Table, you have the YearMonthnumber column
4. In your visual, you will drag the YearMonthnumber field from the Calendar Table