Forum Discussion

dalmn21's avatar
dalmn21
Frequent Visitor
3 years ago

IF Statement

Hi,

 

I am fairly new to DAX and spent some time finding ways to fix my issue before posting here! I am wanting to create a measure to put into a scorecard that shows the percent change depending on what name and day is chosen. This report is updated daily. 

 

For example:

If I choose "ABC" then it would use an equation I created for A (eq_ABC) else it would show the result for B (eq_DEF)

I've tried using this measure I created and it works to an extent. When ABC is chosen, it will show the results for Eq_ABC. When DEF is chosen, it still uses Eq_ABC for some reason. 

IF(CONTAINS(Main , Main[Name], "ABC"), Main[Eq_DEF], Main[Eq_ABC])

 

I've tried creating a calculated column, but it doesn't give me a percentage for a given day that has been chosen. It summarizes it (I changed it to don't summarize, but I also don't need the average, count, and min/max). 

IF(Main[Name] = "ABC", Main[Eq_ABC], Main[Eq_DEF])
 
Thanks in advance! 
Need Help

5 Replies

    • dalmn21's avatar
      dalmn21
      Frequent Visitor
      3 years ago

      Greg_Deckler 

       

      I'm getting a "The MAX function only accepts a column reference as an argument" error. 

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        3 years ago

        dalmn21 If that is a measure ( [Name] ), then just drop the MAX and reference the measure directly (no need to specify the table). Otherwise, you could try MAXX which accepts a table expression.

  • LQuedas's avatar
    LQuedas
    Resolver II
    3 years ago

    dalmn21 ,

     

    you can try to use variables, try this example:

     

    NewMeasure =
    var _f1 = count('Product'[Product Name])
    var _f2 = 1000
    return if(CONTAINS('Product','Product'[Product Name],"Product A"),_f1,_f2)

    this measure uses only the _f1 formula to the product A

     

    Hope this helps

     

    Cheers, LQ

    • dalmn21's avatar
      dalmn21
      Frequent Visitor
      3 years ago

      LQuedas 

       

      Thank you for the reply! Unfortunately, I get the same result as one of my examples where the second name option is using the incorrect equation.