Nested If Statement

Question

The DAX measure code below returns the engagement count and also term and year.&nbsp; I only want the selected term to show for example "Fall", but I get both Fall and Spring as shown below.&nbsp;&nbsp;If I remove one If statement and run for either "Fall" or "Spring", I generate the correct ouput.&nbsp;I am sure the issue is with the commas, but I am not sure how to make this an (If, Yes, No) statement.&nbsp;&nbsp;I greatly appreeciate your assistance with t his formatting issue.-----------------------------------------------------------------------------------------------------------------------------&nbsp;VAR _program = Enrollment[ProgramSelection]VAR _termyear = Enrollment[TermYearSelection]VAR _intdate = (Int(Right(Enrollment[AYYearSelection],4)))VAR _sterm = LEFT(SELECTEDVALUE(Enrollment[Start Term and Year]),2)&nbsp;VAR _enddate = SWITCH(_intdate,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2024, TODAY(),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2023, TODAY(),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2022, &nbsp;EDATE(TODAY(), -12),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2021, &nbsp;EDATE(TODAY(), -24),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2020, &nbsp;EDATE(TODAY(), -36),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2019, &nbsp;EDATE(TODAY(), -48)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )VAR _count1 = &nbsp; IF( _sterm = "Fa", &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CALCULATE(COUNTROWS(Enrollment),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Enrollment[Program] = _program, &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Enrollment[Start Term and Year] = _termyear,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Enrollment[Deposit Intent to Enroll] = "Yes",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Enrollment[TermName] = SELECTEDVALUE(FallFilter[Term])),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF( _sterm = "Sp", &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CALCULATE(COUNTROWS(Enrollment),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Enrollment[Program] = _program, &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Enrollment[Start Term and Year] = _termyear,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Enrollment[Deposit Intent to Enroll] = "Yes",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Enrollment[TermName] = SELECTEDVALUE(SpringFilter[Term]))) &nbsp; &nbsp; &nbsp; &nbsp; )RETURN_count1

greg_deckler · Answer

Anonymous&nbsp;Try using SWITCH instead of nested IF statements.

Forum Discussion

Nested If Statement

1 Reply

Related content

Power Query Nested IF AND Statement

Nested IF/AND Statement

Multiple nested IF statements

Nested switch statements?

DAX Measure with Nested IF Statements