Hey @powerbi1868 ,
not sure if I understand you correctly, but maybe this is doing what you are looking for:
, calculate( average( '<yourtablenema>'[perfectoder] ) , '<yourtablenema>'[perfectoder] = 1 )
Hopefully, this provides what you are looking for.
If not, consider creating a pbix file that contains sample data, but still reflects your data model (tables, relationships, calculated columns, and measures). Upload the file to onedrive, google drive, or dropbox and share the link. If you are using Excel to create the sample data, share the xlsx as well.
Did I answer your question? Mark my post as a solution, this will help others!
Proud to be a Super User!
I accept Kudos 😉