Filtering data in SSAS based on "AND", not "OR"

Question

In SSAS I have this simple scheme with a list of partners with their tags and the directory of tags. With this scheme, filtering by tags works on the principle "OR" - one of the tags selected by user in the directory can be present for a partner - the partner will be selected.

And how to do this: all selected tags (principle "AND") from the directory of tags must be present for a partner in the partner table and only in this case the partner will be selected.

Sam Nseir · Accepted Answer · 2025-03-29 13:57:51Z

0

Create a measure similar to this one:

FlagSlicerAND = 
  var slicerCount = IF(ISFILTERED(Tags[Tag]), COUNTROWS(ALLSELECTED('Tags')), 0)
  var partnerTagCount = DISTINCTCOUNT(Partners[TagId])

  return IF(slicerCount = 0 || slicerCount = partnerTagCount, 1, BLANK())

You can then either add this measure as a Visual Filter and set it to is not blank, and/or use it in your other measures within, eg:

Total Partners = 
  SUMX(
    DISTINCT(Partners[PartnerId]),
    [FlagSlicerAND]
  )

answered Mar 29 at 13:57

Sam Nseir

13.1k2 gold badges5 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Filtering data in SSAS based on "AND", not "OR"

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related