Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Using parameter in calculation

Hi, I am trying to use the user selection to calculate a measure: User will provide me the RetirementAge parameter, and based on the user selection I want to calculate the total FTE that is abo...
Need Help
Show and Tell
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    Anonymous Try:

    SUMX(FILTER('1'
     ,'1'[Age] >= RetirementAge[RetirementAge Value]
     ,[FTE]
)


that's if RetirementAge Value is a measure
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

Anonymous Try:

SUMX(FILTER('1'
     ,'1'[Age] >= RetirementAge[RetirementAge Value]
     ,[FTE]
)


that's if RetirementAge Value is a measure
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Great, worked nicely.
    I also had a variable, so had to use together with CALCULATE:

    HC_RetirementAge =

    VAR
        EndDate = LASTDATE('Dates'[Date ID])
    Return
        CALCULATE(SUMX(FILTER('1' ,'1'[Age] >= RetirementAge[RetirementAge Value])
        , '1'[HC_ED])

        ,'1'[Event Date] = EndDate 
        , '1'[Data Type] = "Headcount"
        )

    Thank you !