DAX IF ELSE ERROR

[Anonymous]

Hi All,

i am learning PowerBI and Stucked with below issue.

Table Name: Dim1
ID	Direction
1	Up
2	Down
3	Up
4	Up
5	Down

Fact_1
ID	Caltegory	Sales	Budget
1	A	2	2
2	B	3	1
3	C	4	2
4	D	3	3
5	E	5	4

I want to write somthing like this in my measure: Measure=If(Dim1[Direction]="Up"),'Fact_1'[Sales], 'Fact_1'[Budget])

Thanks,

KSR

[CNENFRNL]

Hi, @Anonymous , your formula works in a calculated column; as measure, the syntax is a bit different,

Measure =
IF (
    MAX ( Dim1[Direction] ) = "Up",
    MAX ( 'Fact_1'[Sales] ),
    MAX ( 'Fact_1'[Budget] )
)