Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

What if parameter increased per year

Hi, Im trying to create a What if parameter for end user to select "attrition rate" for example user would select 5% per year. Then in my "Line and stacked column chart" i would have x axis as da...
DAX
  • camargos88's avatar
    camargos88
    6 years ago

    Anonymous ,

     

    You need to create this measure:

     

    _Accumulate = SUM('Table'[Employees]) - ((RANKX(ALL('Table'[Year]), CALCULATE(MIN('Table'[Year])),, ASC) * Parameter[Parameter Value]) * SUM('Table'[Employees]) / 100)

     

     

     

    Check the attached file.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , Try a measure like

measure  =
var _min = minx(allselected(Table), Table[Year])
var _sel = selectedvalue(Slicer[slicer]) //what if value 
return 
calculate( sum(Table[Employees]) -  (((max(Table[Year]) -_min)+1) * _sel * sum(Table[Employees]))/100)