Forum Discussion

ManuApo's avatar
ManuApo
Icon for Helper II rankHelper II
4 years ago
Solved

Struggling 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 ...
General Comment
Need Help
Tips and Tricks
  • ManuApo's avatar
    ManuApo
    4 years ago

    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
ALLUREAN's avatar
ALLUREAN
Icon for Solution Sage rankSolution Sage
4 years ago

Hi, ManuApo 
Try this:

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

                           ALL(Dim_Calendar[Year])
                           )
ManuApo's avatar
ManuApo
Icon for Helper II rankHelper II
4 years ago

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