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 above the RetirementAge:



In the above scenario, if the user selects 60 as retirement age, my desired output is 1+0.5 =  1.5.

Similarly for user selection 85, I only have one employee who is above that age, so the output will be FTE of that employee i.e. 0.5.

How can I achieve this please ?

Thanks !

I have tried:

CALCULATE(
         SUM('1'[FTE])
        ,'1'[Age] >= RetirementAge[RetirementAge Value]
      )


But that gave me error:

A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.

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

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community 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 !