DAX measure add extra results

[spetiteau]

Hi,

I want to compute a monthly running total of the count of published "reference" :

RT_TargetPub = CALCULATE(
    COUNT('Export_D2 (2)'[Référence]),
    FILTER(
        ALL('Export_D2 (2)'[Cible_PUBLICATION].[Date]), 
        'Export_D2 (2)'[Cible_PUBLICATION].[Date]<= MAX('Export_D2 (2)'[Cible_PUBLICATION].[Date])
        )
    )

The outcome is correct until february 2025 (the current month) but I got results for all month of 2025. How can I get results stopping consistently with the last date of my publication?

[bhanu_gautam]

@spetiteau , Try using

RT_TargetPub =
CALCULATE(
COUNT('Export_D2 (2)'[Référence]),
FILTER(
ALL('Export_D2 (2)'[Cible_PUBLICATION].[Date]),
'Export_D2 (2)'[Cible_PUBLICATION].[Date] <= MAX('Export_D2 (2)'[Cible_PUBLICATION].[Date]) &&
'Export_D2 (2)'[Cible_PUBLICATION].[Date] <= MAXX(ALL('Export_D2 (2)'), 'Export_D2 (2)'[Cible_PUBLICATION].[Date])
)
)

[spetiteau]

i've tried

RT_TargetPub = CALCULATE(
    COUNT('Export_D2 (2)'[Référence]),
    FILTER(
        ALL('Export_D2 (2)'[Cible_PUBLICATION].[Date]), 
        'Export_D2 (2)'[Cible_PUBLICATION].[Date]<= MAX('Export_D2 (2)'[Cible_PUBLICATION].[Date]) &&
        'Export_D2 (2)'[Cible_PUBLICATION].[Date] <= MAXX(ALL('Export_D2 (2)'), 'Export_D2 (2)'[Cible_PUBLICATION].[Date]) &&
        'Export_D2 (2)'[Cible_PUBLICATION].[Date] <> BLANK()
        )
    )

I have still the same result