Forum Discussion
Helper IIStruggling with a DAX measure :( Help!Help!Help!!
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:
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]))RETURNCALCULATE( 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
4 Replies
- amitchandak
Super User
ManuApo ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
ManuApoHi 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
