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 !