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

Hey,

this will resolve the error message
CALCULATE(
< your expression >

,ALLEXCEPT('yourtablename', 'yourtablename'[name of the calculated column 1])
)

 

Regards Tom

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Ok SO update my expression to : 

 

Unit Level = CALCULATE(IF(SUM([Avg Units])<9,"Blue",IF(SUM([Avg Units])>=18,"Gold","Silver")),ALLEXCEPT('Last Quarter','Last Quarter'[Avg Units]))

 

 

but still getting all gold results. This shouldn't be this hard. What am I missing? 

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      I coppied a section of my table in the question. The loan number is just a unique identifier i use to get a count of units. 

       

       

      • TomMartens's avatar
        TomMartens
        Super User
        8 years ago

        Hey,

         

        unfortunately I can't fully reproduce your issue, based on your sample data, due to the missing column that you used for your "Calculated Column".

         

        Did you check the other option and did you already checked the article.

         

        Regards

        Tom