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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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's avatar
    ManuApo
    Icon for Helper II rankHelper II
    4 years ago

    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'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