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,

 

I assume that Unit Level is also a calculated column.

 

Put the expression inside a CALCULATE( ... ) this should solve your problem.

 

Using SUM(...) means always aggregate the available rows of the table considering the current Filter Context.

Definig a calculated column one has to consider that there is no Filter Context, just a Row Context. This means using SUM(...) aggregates all the rows, for this reason you just have "Gold".

 

Two possibilities

  • Wrap CALCULATE around the expression. CALCULATE( ) introduces  a Filter Context. Using CALCULATE() inside a Row Context means, the Filter Context is just the current row, this of course can be changed by adding more than just the 1st parameter - the expression.
  • Remove the SUM()s from your expression, to reference a value from a certain column inside a Row Context it's not necessary to use SUM

Hope this helps

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

THe Unit Level Calculation is Unit Level = IF(SUM([Avg. Units])<9,"Blue",IF(SUM([Avg. Units])>=18,"Gold","Silver"))

 

If I add calculate to this i get a "Circular Dependency was detected"