filter out from selection

eliasayyy — Thu, 15 Jun 2023 12:23:27 GMT

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

Re: filter out from selection

eliasayyy — Thu, 15 Jun 2023 12:32:56 GMT

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)

topic Re: filter out from selection in DAX Commands and Tips

filter out from selection

Re: filter out from selection