topic DAX measure add extra results in DAX Commands and Tips

DAX measure add extra results

spetiteau — Mon, 03 Feb 2025 15:16:41 GMT

Hi,

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

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?

Re: DAX measure add extra results

bhanu_gautam — Mon, 03 Feb 2025 15:35:43 GMT

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])
)
)

Re: DAX measure add extra results

spetiteau — Mon, 03 Feb 2025 15:52:57 GMT

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