Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

IF Function

Hello,  I'm still learning all of this DAX and Power BI function writing. I am trying to get the below to break out a column into 3 levels? It's only picking up the GOLD level.    Unit Level = IF(...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

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

TomMartens's avatar
TomMartens
Super User
8 years ago

What the article explains, is why you get the error message, so I guess it should mean something.

 

Yes I can't reproduce your issue, because I can't use your formula, to recreate a calculated column (the root case, for the error message) by using calculate.

 

This makes it impossible to help you any further, because the issue can't be recreated by the  data you provided.

 

Regards

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

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

  • TomMartens's avatar
    TomMartens
    Super User
    8 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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)

     

     

  • TomMartens's avatar
    TomMartens
    Super User
    8 years ago

    Just one final question

     

    What are calculated columns and what are measures?

     

    Regards

    Tom

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    They are all calculated columns.