cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Millser
New Member

Quick Question about using IF statements for filtering in power bi

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.")
1 ACCEPTED SOLUTION
Payeras_BI
Super User I
Super User I

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."
)

 

If this post answered your question, please mark it as a solution to help other users find useful content.
Kudos are another nice way to acknowledge those who tried to help you.

J. Payeras
Mallorca, Spain

View solution in original post

1 REPLY 1
Payeras_BI
Super User I
Super User I

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."
)

 

If this post answered your question, please mark it as a solution to help other users find useful content.
Kudos are another nice way to acknowledge those who tried to help you.

J. Payeras
Mallorca, Spain

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Kudoed Authors