Forum Discussion
XeperRx
5 years agoFrequent Visitor
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
5 years agoFrequent Visitor
This solution does not work, it displays the same information already present in the first column.
v-easonf-msft
5 years agoCommunity Support
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