Cumulative Measures based on other Measures

[Anonymous]

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 like to create another measure which hold the values like if i select Quarterly trend then it need to dosplay quarterly values measure.

if i select Weekly trend then it need to dosplay weekly values measure.

if i select Yearly trend then it need to dosplay Yearly values measure.

I want this in a single measure.

Thanks in advance

[Gordonlilj · Accepted solution]

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])