Forum Discussion

DNA's avatar
DNA
Frequent Visitor
8 years ago
Solved

Help - Need New Measure to Sum Up Records

I wanting help writing out a new measure to sum up information within the below table. Power Bi isn't quite calculating an average for me correctly, so I believe I need one more step in the process. ...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    DNA

     

    May be

     

    Measure =
SUM ( Table1[Markup Dollars] ) / DISTINCTCOUNT ( Table1[Loan Number] )
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

DNA

 

May be

 

Measure =
SUM ( Table1[Markup Dollars] ) / DISTINCTCOUNT ( Table1[Loan Number] )