Create static a column in table

[XeperRx]

Hello, 

I have table in my report that looks like this : 

By selecting a name from the Employee Name slicer, it shows me that specific employees average build time for each part they worked on, along with the min and max time. I need to add a fourth column that will show the overall average build time of all employees  which remains static, essentially the state that the column is in before filtering the table. 

Thanks, 

[v-easonf-msft]

Hi , @XeperRx 

Could you please tell me whether your problem has been solved?
If it is,  please mark the helpful replies or add your reply as Answered to close this thread.
It will help other community members easily find the solution when they get the similar issue.

Best Regards,
Community Support Team _ Eason

[TomMartens]

Hey @XeperRx ,

I guess you need a measure that looks like this:

average without filter = 
calculate(
average('tablename'[buildtime])
all('tablename')
)

The measure creates an average value that ignores all existing filters.

Here you will find some guidance on how to create measures: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-tutorial-create-measures

Hopefully, this provides what you are looking for.

Regards,

Tom

[XeperRx]

This does not work. It displays the over all average of all build times with the same repeating number. I need the column to display the average for the specific part number of that particular row. The first column would change based on the employee average time for that specific part number.

[Fowmy]

@XeperRx 

Create a new measure with this code and add it to the table.

Overall Average = CALCULATE( AVERAGE(TABLE[TOTAL BULD TIME]) , ALL( TABLE[EMPLOYEE NAME]))

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[XeperRx]

This solution does not work, it displays the same information already present in the first column.

[v-easonf-msft]

Hi , @XeperRx 

Not   very clear.

Have you tried to use the finction "allexcept" rather than "all".

something like:

Measure = CALCULATE( AVERAGE(TABLE[TOTAL BULD TIME]) , ALLExcept( Table ,TABLE[EMPLOYEE NAME]))

It would be better if you can share the expected results in excel and share your sample pbix file in onedrive.

Best Regards,
Community Support Team _ Eason