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
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.