https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-IF-ELSE-ERROR/m-p/1544885#M30493 <P>Hi All,</P><P>&nbsp;</P><P>i am learning PowerBI and Stucked with below issue.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Table Name: Dim1</TD></TR><TR><TD>ID</TD><TD>Direction</TD></TR><TR><TD>1</TD><TD>Up</TD></TR><TR><TD>2</TD><TD>Down</TD></TR><TR><TD>3</TD><TD>Up</TD></TR><TR><TD>4</TD><TD>Up</TD></TR><TR><TD>5</TD><TD>Down</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Fact_1</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>ID</TD><TD>Caltegory</TD><TD>Sales</TD><TD>Budget</TD></TR><TR><TD>1</TD><TD>A</TD><TD>2</TD><TD>2</TD></TR><TR><TD>2</TD><TD>B</TD><TD>3</TD><TD>1</TD></TR><TR><TD>3</TD><TD>C</TD><TD>4</TD><TD>2</TD></TR><TR><TD>4</TD><TD>D</TD><TD>3</TD><TD>3</TD></TR><TR><TD>5</TD><TD>E</TD><TD>5</TD><TD>4</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want to write somthing like this in my measure: Measure=If(Dim1[Direction]="Up"),'Fact_1'[Sales],&nbsp;'Fact_1'[Budget])</P><P>&nbsp;</P><P>Thanks,</P><P>KSR</P> Fri, 11 Dec 2020 08:25:04 GMT Anonymous 2020-12-11T08:25:04Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-IF-ELSE-ERROR/m-p/1544885#M30493 <P>Hi All,</P><P>&nbsp;</P><P>i am learning PowerBI and Stucked with below issue.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Table Name: Dim1</TD></TR><TR><TD>ID</TD><TD>Direction</TD></TR><TR><TD>1</TD><TD>Up</TD></TR><TR><TD>2</TD><TD>Down</TD></TR><TR><TD>3</TD><TD>Up</TD></TR><TR><TD>4</TD><TD>Up</TD></TR><TR><TD>5</TD><TD>Down</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Fact_1</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>ID</TD><TD>Caltegory</TD><TD>Sales</TD><TD>Budget</TD></TR><TR><TD>1</TD><TD>A</TD><TD>2</TD><TD>2</TD></TR><TR><TD>2</TD><TD>B</TD><TD>3</TD><TD>1</TD></TR><TR><TD>3</TD><TD>C</TD><TD>4</TD><TD>2</TD></TR><TR><TD>4</TD><TD>D</TD><TD>3</TD><TD>3</TD></TR><TR><TD>5</TD><TD>E</TD><TD>5</TD><TD>4</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want to write somthing like this in my measure: Measure=If(Dim1[Direction]="Up"),'Fact_1'[Sales],&nbsp;'Fact_1'[Budget])</P><P>&nbsp;</P><P>Thanks,</P><P>KSR</P> Fri, 11 Dec 2020 08:25:04 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-IF-ELSE-ERROR/m-p/1544885#M30493 Anonymous 2020-12-11T08:25:04Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-IF-ELSE-ERROR/m-p/1545102#M30501 <P>Hi,&nbsp;Anonymous</LI-USER>&nbsp;, your formula works in a calculated column; as measure, the syntax is a bit different,</P><LI-CODE lang="markup">Measure = IF ( MAX ( Dim1[Direction] ) = "Up", MAX ( 'Fact_1'[Sales] ), MAX ( 'Fact_1'[Budget] ) )</LI-CODE><P>&nbsp;</P> Fri, 11 Dec 2020 09:49:14 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-IF-ELSE-ERROR/m-p/1545102#M30501 CNENFRNL 2020-12-11T09:49:14Z