YTD Calculation Not working in Power BI Direct Query

[Anonymous]

I have created a measure for YTD calculation but it returns no results, not sure what I am doing wrong

YTD SALES = CALCULATE (

SUM('Group Results'[FC_OCC8_CLAIMS]),

FILTER (

ALL ( 'CalendarGroup' ),

CalendarGroup[Day Date] <= MAX ( CalendarGroup[Day Date] )

&& YEAR ( CalendarGroup[Day Date] ) = YEAR ( MAX ( CalendarGroup[Day Date] ) )

)

)

[v-yuta-msft]

@Anonymous ,

Could you please share some sample data and clarify more details about your requirement?

Regards,

Jimmy Tao

[Anonymous]

What is the other relationship connected to Group Results. That formula looks like it should work.