If than else in DAX

[Petersx]

Good Morning,

i have my next problem.....

I have a Table with column A;B,C
A = 1 or 0
B = Value
C = only A = 0 than Value from B

Can anybody help me? Me idea with calculate and filte does not work.....

best regards,
Peter

 

[olivierhbh]

Hello Peter,
I'm not sure what you want to do but the syntax for an IF statement is:
IF(Logical Test, Result if true, Result if false), for example: IF([column1]=1, "Yes", "No").

Calculate is useful for conditional aggregating, for example:
CALCULATE(SUM([column1]), [column2]>0)

*Structure: CALCULATE(Expression, Filter1, Filter2...)

Olivier.

 

[Petersx]

Hello Peter,
I'm not sure what you want to do but the syntax for an IF statement is:
IF(Logical Test, Result if true, Result if false), for example: IF([column1]=1, "Yes", "No").

Calculate is useful for conditional aggregating, for example:
CALCULATE(SUM([column1]), [column2]>0)

*Structure: CALCULATE(Expression, Filter1, Filter2...)

Olivier.

Good Morning Oliver,

i have a column with values and a column with a 1 or 0. Now i would create a new column. In this column there are only the value for the expression:
If Qualitiy 1 than Value

For Example:

Qualitiy | Value | New Column
0 ...........10.............-
1 ...........8.............8
0 ...........15.............-
0 ...........20.............-
1 ...........100..........100



hopefully it helps....

 

[olivierhbh]

Good morning Peter,

Then the formula in New Column should be: IF([Quality]=1, [Value], "-"), if by "-" you meant blank, you can replace it by "".

Olivier.

Ps: It's If, Then, Else