Dax measure working at points level but not at calendar table level

[sivarajan21]

Hi,

I have created a dax measure for forecast and used it in visual as below:

But when I had done a validation for this below measure found that it causes a issue. The measure is below one:

What I had observed is this measure works at Points[DBName-Point_id] level but does not filter correctly for calendar table columns like Financial year or months.

My expected outcome would be,want this measure to work both at Points[DBName-Point_id] level and also when filtered by calendar table level.

PFA file in below location

Portfolio Performance - Live (1).pbix

Please let me know if you need further info!

Thanks in advance!

@Ahmedx @Greg_Deckler @amitchandak @Ashish_Mathur @grantsamborn @Sergii24 

[Greg_Deckler · Accepted solution]

@sivarajan21 What happens if you ditch CALCULATE and replace your VALUES with SUMMARIZE?

[sivarajan21]

Hi Sir,

This worked for me thanks a lot!

I have accepted it as a solution☺