Forum Discussion

ephramz's avatar
ephramz
Helper II
4 years ago

Help with measure

 


When I slice the "Created Date"(which represents the year), Median Actual Time values will change.
The measure is as follows:

Median Actual Time =
SUMX(
ADDCOLUMNS(VALUES('ENGG VW_TRM'[Op. No.]),
"Median Actual Time1",[Median Actual Time1]
),[Median Actual Time1]
)


Median Actual Time1 measure : 

Median Actual Time1 =
VAR compare_ =
IF(DIVIDE([Average Time] - [Median1], [Median1]) >= 0.50 || DIVIDE([Average Time] - [Median1], [Median1]) <= -0.50,1,0)
RETURN
IF(compare_=1,[Average Time] ,[Median1])


How can i alter the Median Actual Time measure such that i can save the different values into a calcualted column for all the Years.

Let's call this table, Table1, where i have all the "Created Date" 

Need Help

2 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    4 years ago

    Hi,

    I don't think the result of a measure can be saved as a calculated column in a fact table.

  • MFelix's avatar
    MFelix
    Super User
    4 years ago

    Hi ephramz ,

     

    Has Ashish_Mathur refered you cannot save a measure in a calculated table you would need to redo your calculation of the median has part of your column.

     

    But what is the use you want to give to that value? Measure can be used to calculated other measures, so in this case you can use a temptable on your measures where you ahve the CreatedDates and the Median and then use for your calculations.

     

    Can you specify what do you need to store this value?