Forum Discussion
ManuApo
Helper II
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 ...
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
ManuApoHelper II
Helper IIHi 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
Solution Sage
Solution Sage- ManuApo
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