I think using LOD with Exclude wouldn't accomplish your goals: LODs are designed to operate on entire dimensions, and not on individual values that are filtered in our out.
I propose a different approach: self-join on Company. Then you can define a calculated field that should serve your purpose as follows:
SUM(IF([Company (Sheet11)]==[Company]) THEN 0 ELSE [Value (Sheet11)] END)/
SUM(IF([Company (Sheet11)]==[Company]) THEN 0 ELSE 1 END)
Attaching a workbook that shows this approach. I named the calculated field I defined above PeerAvgByCompany. I dragged Date to Columns, the new calculated field to Rows, and Company to Color.
Hope this helps. Let me know if you have other questions.
Peer ROIC.twbx 34.1 KB
Apologies for the delayed reply to this. Thank you for looking at the file. I will try to implement the solution in my project. If in case I come across any issue, will need your help again.