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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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] )

Regards
Zubair

Please try my custom visuals

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] )

Regards
Zubair

Please try my custom visuals

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.