Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during AI Skills Fest. This week only. Secure your voucher now.

Reply
DNA
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
Zubair_Muhammad
Community Champion
Community Champion

@DNA

 

May be

 

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

View solution in original post

1 REPLY 1
Zubair_Muhammad
Community Champion
Community Champion

@DNA

 

May be

 

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

Helpful resources

Announcements
May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.