Help with a Formula

[BrandiHutch]

I am in property management and in my report I am trying to get a dollar per unit for my delinquency by project.  The issue I am having is BI to recogonize my individual projects unit counts.  I can get my total unit counts and my total project count, but for the life of me the individual unit count by project is not working.  

[BrandiHutch]

I created a table called Agent which I was able to group by Agent.  I still cannot get the total unit count by Agent from the information in the Project Info table.    Projects are by Agent and each project has a total unit count which is what I am trying to add so I get a total unit count by Agent.

[amitchandak]

@BrandiHutch , Please share some sample data

Usually, we can use

countrows(Summarize(Table, Table[Project],Table[Unit]))

In case the cost repeats and you want some distinct combination

Sumx(Summarize(Table, Table[Project],Table[Unit], Table[Cost]),  [Cost])

Otherwise

Sum(Table[Cost])

Or

Sumx(Table, Table[Cost] * Table[Unit]) //In case unit is number and need multiplication