Forum Discussion

BrandiHutch's avatar
BrandiHutch
New Member
2 years ago

Help with a Formula

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.  

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    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

     

  • BrandiHutch's avatar
    BrandiHutch
    New Member
    2 years ago

    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.