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 o...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

dalmn21 Maybe:

Measure = IF(MAX(Main[Name]) = "ABC", Main[Eq_ABC], Main[Eq_DEF])
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.