cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

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.   

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User I
Super User I

@DNA

 

May be

 

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


View solution in original post

1 REPLY 1
Super User I
Super User I

@DNA

 

May be

 

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


View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors