Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
eliasayyy
Memorable Member
Memorable Member

filter out from selection

hello everyone i made a field parameter table as shown here and added a new column type  :

annonymous1999_0-1686831527444.png



i added a slicer and added the "Type" column to it and made another slicer and added "Name" to it and i have something like

annonymous1999_1-1686831602007.png


in this example, all fields of second slicer for "Video" are empty such as 

annonymous1999_2-1686831654009.png


i made a measure

FB Campaign Switch Measures = 
SWITCH(
    SELECTEDVALUE('PM For FB Campaign'[Order]),
    0, [FB Campaign Impressions],
    1, [FB Campaign Link Clicks],
    2, [FB Campaign Messages],
    3, [FB Campaign Reach],
    4, [FB Campaign Click Through Rate],
    5, [FB Campaign Landing Page Views],
    6, [FB Campaign Messaging Rate],
    7, [FB Campaign Post Engagement],
    8, [FB Campaign Frequency],
    9, [FB Campaign 25% Played],
    10, [FB Campaign 50% Played],
    11, [FB Campaign 75% Played],
    12, [FB Campaign 95% Played],
    13, [FB Campaign 100% Played],
    14, [FB Campaign 2s Continuous Plays],
    15, [FB Campaign 3s Plays],
    16, [FB Campaign ThruPlays],
    17, [FB Campaign Video Plays],
    18, [FB Campaign Leads],
    19, [FB Campaign Post Comments],
    20, [FB Campaign Post Reactions],
    21, [FB Campaign Post Saves],
    22, [FB Campaign Post Shares],
    23, [FB Campaign Add To Wishlist],
    24, [FB Campaign Adds to Cart],
    25, [FB Campaign Purchases],
    26, [FB Campaign Cost],
    27, [FB Campaign Cost Per Click],
    28, [FB Campaign Cost Per Lead],
    29, [FB Campaign Cost Per Messages],
    30, [FB Campaign Cost Per Purchase],
    31, [FB Campaign Cost Per Reach],
    32, [FB Campaign Cost Per Thousand]
)

 

Filter out = 
IF(
    SUMX(VALUES('PM For FB Campaign'[Type]),[FB Campaign Switch Measures]) = 0 , 1, 0)


as you see if i add the filter out as a card it shows 1 and 0 it works 

if i add it to the second slicer it works

annonymous1999_3-1686831745163.png



but when i add it to the "Type" Slicer, all values dissapear

annonymous1999_4-1686831800804.png



can someone help me out

1 ACCEPTED SOLUTION
eliasayyy
Memorable Member
Memorable Member

i made it work i just change the measure

FB Campaign Filter out = 
IF(
    SUMX(VALUES('PM For FB Campaign'[Order]),[FB Campaign Switch Measures]) = 0 , 1, 0)

View solution in original post

1 REPLY 1
eliasayyy
Memorable Member
Memorable Member

i made it work i just change the measure

FB Campaign Filter out = 
IF(
    SUMX(VALUES('PM For FB Campaign'[Order]),[FB Campaign Switch Measures]) = 0 , 1, 0)

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.