Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Cumulative Measures based on other Measures

Hi All,   I have a period column where i will have 3 values Quarterly Trend, Weekly Ttrend and Yearly Trend.   I created 3 different measures for all these 3 vlues.   Now i would li...
Need Help
  • Gordonlilj's avatar
    Gordonlilj
    6 years ago

    Hi,

     

    You could try creating a measure like below

    Measure = 
SWITCH(TRUE(),
SELECTEDVALUE('Table'[Period]) = "Weekly trend",[Weekly values],
SELECTEDVALUE('Table'[Period]) = "Quarterly trend",[Quarterly values],
SELECTEDVALUE('Table'[Period]) = "Yearly trend",[Yearly values])

     

Gordonlilj's avatar
Gordonlilj
Icon for Solution Sage rankSolution Sage
6 years ago

Hi,

 

You could try creating a measure like below

Measure = 
SWITCH(TRUE(),
SELECTEDVALUE('Table'[Period]) = "Weekly trend",[Weekly values],
SELECTEDVALUE('Table'[Period]) = "Quarterly trend",[Quarterly values],
SELECTEDVALUE('Table'[Period]) = "Yearly trend",[Yearly values])