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.  Below are the some example details. 

 

Table Name: FactMarkupApplied

 

Loan NumberMarkup TypeMarkup Dollars
12345Branch300
12345Retail100
45678Branch350
45678Retail450

 

I want a measure that sums up the total markup dollars for a given loan number. 

 

Loan 12345 total markup dollars is $400

Loan 45678 total markup dollars is $800

 

The reason I want a measure is so I can pull that measure into a visualiation and then take the average markup dollars by loan number.  In the above example, the average markup dollars by Loan Number is $600.   

 

Need Help

1 Reply

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    DNA

     

    May be

     

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