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...
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.
