cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ephramz
Helper II
Helper II

Help with measure

ephramz_0-1637023145178.png

 


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" 

2 REPLIES 2
MFelix
Super User
Super User

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?


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Ashish_Mathur
Super User
Super User

Hi,

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!