Slicer With Selected Terms AND'd Not OR'd

Question

Hello,&nbsp;I am using&nbsp;Attribute Slicer&nbsp;custom visual but as they said: All selected terms are OR'd together. AND is not an available option currently. &nbsp;&nbsp;Are there any workaround for these situation ? &nbsp;I am using SSAS live connector. &nbsp;I could use standard slicer or use multiple slicer (put 3 slicer to be and'd), duplicate dimension or different type of relation.&nbsp;For that example I want to get tweets that contains #SQL&nbsp;and&nbsp;#PowerBi&nbsp;&nbsp;Thanks,

mattallington · Answer

You therefore need to write a measure that returns a non blank result when your pattern is matched. In your sample data, something like this

=if(distinctcount(table[hashtagkey])=distinctcount(table[tweetkey]),1)

mattallington · Answer

A slicer is used on a column. E.g., the adventure Works database has a column called category, with possible values bikes, clothing, accessories and categories. If the slicer was a logical and, it would be like saying "show me all products that are both a "Bike" and also "clothing". It is impossible to be both, so a logical and would always return nothing. Given this, I don't understand the use case for a logical and using a slicer on a column.&nbsp;Spoiler (Highlight to read)&nbsp;&nbsp;

alpcoker · Answer

Thank you for your attention.&nbsp;There isn't any example of that on AdventureWorks DW. But I can try to explain my use case with twitter dataset used on example of Attribute Slicer Custom Visual.&nbsp;HashtagsHashtagKeyHashtagText1#SQL2#PowerBI&nbsp;TweetsTweetKeyTweet Text1#SQL 2016 SP1 is out2#PowerBI Desktop November update released3#PowerBI on premise only works with #SQL Analysis Service&nbsp;live query for now.&nbsp;&nbsp;&nbsp;IntermediateTable&nbsp;TweetKeyHashtagKey11223132&nbsp;&nbsp;If I select single hashtag there is no problem but if I select&nbsp;#SQL and #PowerBI with slicer or attribute slicer I will get all tweets. (1,2,3). But in my case I just want to list only tweet #3 that contains #SQL and #PowerBI together.&nbsp;Thanks,

alpcoker · Answer

Thank you for your help.&nbsp;As you suggest, I create Distinct Count of Hashtag Key&nbsp;measure but I can't get how many numbers of hashtag selected on attribute slicer while creating them.&nbsp;So I create Matching1, Matching2, Matching3 measure to check distinct count value as a temporary solution.&nbsp;You suggest to check equality of distinct counts of&nbsp;HashtagKey and TweetKey. But should be HashtagKey and TweetHashtagKey ?&nbsp;If I could check Number of Hashtag Selected = Distinct Count of Hashtag Key, one measure would be enough? &nbsp;Is there any way to get the count of selected dimensions when writing measure, or any ideas on these screenshot to make it done with one measure?&nbsp;Thanks,&nbsp;My measures are listed as follows;&nbsp;CREATE MEMBER CURRENTCUBE.[Measures].MatchingAllAS iif([Measures].[Tweet Hashtag Count] &gt; 0, iif([Measures].[Hashtag Key Distinct Count] = [Measures].[Tweet Hashtag Count], 1, NULL), NULL), VISIBLE = 1;&nbsp;CREATE MEMBER CURRENTCUBE.[Measures].Matching1AS iif([Measures].[Hashtag Key Distinct Count] = 1, 1, NULL),VISIBLE = 1; CREATE MEMBER CURRENTCUBE.[Measures].Matching2AS iif([Measures].[Hashtag Key Distinct Count] = 2, 1, NULL),VISIBLE = 1; CREATE MEMBER CURRENTCUBE.[Measures].Matching3AS iif([Measures].[Hashtag Key Distinct Count] = 3, 1, NULL),VISIBLE = 1;

mattallington · Answer

Those measures are not written in DAX. &nbsp;It looks like MDX to me.&nbsp;I have now re-read the previous post and I misunderstood what you wanted.&nbsp;You could try adding 2 slicers and selecting one of the options in each slicer

TweetKey	Tweet Text
1	#SQL 2016 SP1 is out
2	#PowerBI Desktop November update released
3	#PowerBI on premise only works with #SQL Analysis Service live query for now.

Forum Discussion

Slicer With Selected Terms AND'd Not OR'd

5 Replies

Related content

Gallery Terms of Service

Selected slicer

Slicer default selection

Single select slicer

Between date slicer - calender selection

HashtagKey	HashtagText
1	#SQL
2	#PowerBI

TweetKey	HashtagKey
1	1
2	2
3	1
3	2