Quick Question about using IF statements for filtering in power bi

[Millser]

Hey,

The following Query I am using to filter a visual based on the selected term number and week as well as the week number nad corresponding class. In the Query below I only want it to filter by class when the number 3 is selected for the term number. I was wondering if there is a way to incoorperate an IF statement into this query and how the IF statement would be formatted?

Current Comments = COALESCE(CALCULATE(

VALUES('Sequence (2)'[Wellbeing]),

FILTER(

'Sequence (2)',

'Sequence (2)'[Term] = SELECTEDVALUE('Date/Time'[Term Number]) && 'Sequence (2)'[Week] = SELECTEDVALUE('Date/Time'[Term Week Number]) && 'Sequence (2)'[Class] = VALUES('kinStudents (2)'[Class]))),

"No focus statement current available.")

[Payeras_BI · Accepted solution]

Hi @Millser ,

See if this could help you.

Current Comments =
COALESCE (
    CALCULATE (
        VALUES ( 'Sequence (2)'[Wellbeing] ),
        IF (
            SELECTEDVALUE ( 'Date/Time'[Term Number] ) = 3,
            FILTER (
                'Sequence (2)',
                'Sequence (2)'[Term] = SELECTEDVALUE ( 'Date/Time'[Term Number] )
                    && 'Sequence (2)'[Week] = SELECTEDVALUE ( 'Date/Time'[Term Week Number] )
                    && 'Sequence (2)'[Class] = VALUES ( 'kinStudents (2)'[Class] )
            ),
            FILTER (
                'Sequence (2)',
                'Sequence (2)'[Term] = SELECTEDVALUE ( 'Date/Time'[Term Number] )
                    && 'Sequence (2)'[Week] = SELECTEDVALUE ( 'Date/Time'[Term Week Number] )
            )
        )
    ),
    "No focus statement current available."
)