Sum by year

[jyaul786]

Dear Friend,

i have two tables, data(value,id,..) and calendar(date,year,quarter) and are related one to many .

i have date slicer between and calculated profit by measure:

var date_min=CALCULATE(min('Calendar'[Date]),ALL('Calendar'[Date]))

var date_max=CALCULATE(MAX('Calendar'[Date]))

return

CALCULATE(SUM(JDT1[Value]),DATESBETWEEN('Calendar'[Date],date_min,date_max))

its working fine on any visual with category axis.But when i show visual with x axis Year,Quarter. its give wrong data.

could you please help how i can short out.

[whitch]

This bit is not behaving as you're expecting:

ALL('Calendar'[Date])

It only removes filters directly applied to that column.  If the quarter or year columns are filtered, it will do nothing.  I recommend replacing it with ALL('Calendar').  You are not alone in having this issue.  Here's someone else having a similar problem:

https://community.fabric.microsoft.com/t5/Desktop/Cumulative-sum-with-Date-Hierarchy/m-p/797893