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

Re: IF Function

As i said i'm still new. Thanks for the efforst though 

Super User
Super User

Re: IF Function

That's why I was asking for sample data that helps to recreate your issue - helping to solve your issue

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
KGooseman Regular Visitor
Regular Visitor

Re: IF Function

These are the only three raw data columns i'm using: 

 

Loan NumberTotal Loan AmountLoan Officer
1625282231,900.00Joseph Paul Thweatt
1709173424,100.00Michelle Sue Wickett
17058321,158,700.00Michal Ann Joyner
1617838324,185.00Richard Iain Charles Hobson
1702143311,664.00Bari B Fraire
1707777168,000.00Terry Jo Mays
1707583207,000.00Matt Hennessy
1708565812,000.00Joseph Paul Thweatt
17081345,352.00Tobby James Goicoechea
1709111315,000.00Jennifer Lake
1707930204,000.00Stephen Ray Santi
1704651104,405.00Philip Frank Hickenbottom
1706661311,200.00Nicole Semerad
1708184600,000.00Brady S Spangler
1703546141,750.00Michael Patrick Walsh
1704512248,268.00Kevin Douglas Anderson
17089471,120,000.00Jennifer Lake
1706825106,837.00T.C. Smukalla
1710091132,000.00Amy Julien
1707510185,600.00Lisa Diane Reeder
1710969269,920.00Kenneth Matthew Rife
1708492193,030.00Lynnette Gaye Conley
1706991180,550.00Matthew Daniel Posey
1705058200,000.00Matt Hennessy
1708078210,000.00Julie Marie Pos
1704887315,933.00Maureen Elyse Gilbert
1709381424,100.00Kenneth Matthew Rife
1615352549,000.00Brady S Spangler
1700761215,340.00T.C. Smukalla
1703578592,250.00Richard Iain Charles Hobson
1708934216,015.00Matt Hennessy
1708706295,787.00Nicole Annette Meyerink
1708622657,800.00Brady S Spangler
1708699298,400.00Michelle Sue Wickett
1706499252,345.00T.C. Smukalla
170932967,000.00Lisa Diane Reeder
1706309167,700.00Gregg Driggs

 

 

Rank: Rank = RANKX(ALLSELECTED('Last Quarter'),Calculate(Sum('Last Quarter'[Loan Amount]),AllExcept('Last Quarter','Last Quarter'[C LO Name])),,DESC,DENSE)

 

Total Units: Distinct Count of Loan Number

Total Volume ; Sum of Loan Amount

Avg Units is : CALCULATE(DISTINCTCOUNT('Last Quarter'[Loan Number])/3)

Avg Volume: CALCULATE(SUM('Last Quarter'[Loan Amount])/3)

 

 

Super User
Super User

Re: IF Function

Just one final question

 

What are calculated columns and what are measures?

 

Regards

Tom

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
KGooseman Regular Visitor
Regular Visitor

Re: IF Function

They are all calculated columns. 

Highlighted
KGooseman Regular Visitor
Regular Visitor

Re: IF Function

I figured it out!!!! I had to make my expression a measurement and not a calculated column!!!! So embarassed thank you for your help~! 

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 6 members 1,153 guests
Please welcome our newest community members: