Forum Discussion
Create static a column in table
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,
6 Replies
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 🙂
This solution does not work, it displays the same information already present in the first column.
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
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
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.
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
