Forum Discussion

eliasayyy's avatar
eliasayyy
Icon for Memorable Member rankMemorable Member
3 years ago
Solved

filter out from selection

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



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


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


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



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



can someone help me out

  • 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)

1 Reply

  • eliasayyy's avatar
    eliasayyy
    Icon for Memorable Member rankMemorable 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)