Forum Discussion
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~!
These are the only three raw data columns i'm using:
| Loan Number | Total Loan Amount | Loan Officer |
| 1625282 | 231,900.00 | Joseph Paul Thweatt |
| 1709173 | 424,100.00 | Michelle Sue Wickett |
| 1705832 | 1,158,700.00 | Michal Ann Joyner |
| 1617838 | 324,185.00 | Richard Iain Charles Hobson |
| 1702143 | 311,664.00 | Bari B Fraire |
| 1707777 | 168,000.00 | Terry Jo Mays |
| 1707583 | 207,000.00 | Matt Hennessy |
| 1708565 | 812,000.00 | Joseph Paul Thweatt |
| 1708134 | 5,352.00 | Tobby James Goicoechea |
| 1709111 | 315,000.00 | Jennifer Lake |
| 1707930 | 204,000.00 | Stephen Ray Santi |
| 1704651 | 104,405.00 | Philip Frank Hickenbottom |
| 1706661 | 311,200.00 | Nicole Semerad |
| 1708184 | 600,000.00 | Brady S Spangler |
| 1703546 | 141,750.00 | Michael Patrick Walsh |
| 1704512 | 248,268.00 | Kevin Douglas Anderson |
| 1708947 | 1,120,000.00 | Jennifer Lake |
| 1706825 | 106,837.00 | T.C. Smukalla |
| 1710091 | 132,000.00 | Amy Julien |
| 1707510 | 185,600.00 | Lisa Diane Reeder |
| 1710969 | 269,920.00 | Kenneth Matthew Rife |
| 1708492 | 193,030.00 | Lynnette Gaye Conley |
| 1706991 | 180,550.00 | Matthew Daniel Posey |
| 1705058 | 200,000.00 | Matt Hennessy |
| 1708078 | 210,000.00 | Julie Marie Pos |
| 1704887 | 315,933.00 | Maureen Elyse Gilbert |
| 1709381 | 424,100.00 | Kenneth Matthew Rife |
| 1615352 | 549,000.00 | Brady S Spangler |
| 1700761 | 215,340.00 | T.C. Smukalla |
| 1703578 | 592,250.00 | Richard Iain Charles Hobson |
| 1708934 | 216,015.00 | Matt Hennessy |
| 1708706 | 295,787.00 | Nicole Annette Meyerink |
| 1708622 | 657,800.00 | Brady S Spangler |
| 1708699 | 298,400.00 | Michelle Sue Wickett |
| 1706499 | 252,345.00 | T.C. Smukalla |
| 1709329 | 67,000.00 | Lisa Diane Reeder |
| 1706309 | 167,700.00 | Gregg 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)
Just one final question
What are calculated columns and what are measures?
Regards
Tom
I figured it out!!!! I had to make my expression a measurement and not a calculated column!!!! So embarassed thank you for your help~!
They are all calculated columns.