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