Struggling with a DAX measure :( Help!Help!Help!!

[ManuApo]

Hello community, 

I am struggling to create few measures with the same end point, hopefully someone can help me. 

I have a dimension calendar table with a relationship to my fact table. I have a date slicer that I use to filter my visuals. 

I want to create 4 measures based on 4 measures that I have already created where basically removes the date filter slicer but keeps the year i.e. in this case all rows for 2022 

Any suggestions??  

Attached is a screenshot:

[amitchandak]

@ManuApo ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[ManuApo]

Hi @amitchandak , 

The date slicer on top of the screenshot (where it says period) ,  is filtering the 4 measures that are on the table. That is giving me the desired results.

On the other hand I want to create 4 new measures that removes the filter used in the slicer (

Dim_Calendar[FullDateAlternateKey]),   but filters the year used on the slicer. It basically to create a year summary.

It must be something like this....

Measure 1 =
       CALCULATE( SUM('Fact'[GNWP]) ,  

                            FILTER(Dim_Calendar, Dim_Calendar[FullDateAlternateKey].[Year])
                           )

Hope it makes it more clear now, 
Thank you so much!!
Manu
 

[ALLUREAN]

Hi, @ManuApo 
Try this:

Measure 1 =
       CALCULATE( SUM('Fact'[GNWP]) ,  

                           ALL(Dim_Calendar[Year])
                           )

[ManuApo · Accepted solution]

Hi @ALLUREAN and @amitchandak 

this is not working.  But I finally got it working doing this!!!!

Measure 1 =

VAR THISYEAR = YEAR(MAX(Dim_Calendar[FullDateAlternateKey]))

RETURN

CALCULATE( SUM('Fact'[GNWP]), ALLCROSSFILTERED(Dim_Calendar), Dim_Calendar[Year] = THISYEAR)

I dont know how I did it, but it is just working...
Many thanks again