Forum Discussion
eliasayyy
Memorable Member
3 years agofilter 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
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)