Forum Discussion
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 ...
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