Hi,
when i tried to use slicer to specify the date range and KPI to show the number change. it always shows the most recent month number rather than sum of them. (whereas when i put these two measures into a card, it is correct)
i use this measure for my indicator:
CALCULATE(COUNTROWS('leads final'), datesbetween('leads final'[modifiedon (bins)], FIRSTDATE('leads final'[modifiedon (bins)]), LASTDATE('leads final'[modifiedon (bins)])))
this one for my target (which is same period from the last year, like indicator: Jan-Mar, 2019 and target: Jan-Mar, 2018):
target = CALCULATE(COUNTROWS('leads final'), datesbetween('leads final'[modifiedon (bins)], FIRSTDATE(DATEADD('leads final'[modifiedon (bins)], -12, MONTH)),LASTDATE(DATEADD('leads final'[modifiedon (bins)], -12, MONTH))))
more info: "Modifiedon (bins)" is the slicer.
thank you so much
