"and logic" with multiselection in card

[IF]

Hi,

I would like to use "and logic" with multiselection in a slicer. For example; A has x4 and x5 features. A, B, and D have x4 feature. If I select x4 and x5 features, I want to see only A product in the slicer and show the count, which is 1 in a card. I have the example data below as well. 

Thanks in advance!

Product	Features
A	x1
A	x2
A	x3
A	x4
A	x5
B	x1
B	x2
B	x3
B	x4
C	x1
C	x2
C	x3
D	x4

[jdbuchanan71 · Accepted solution]

@IF 
This is a link to the original post for people to reference.
https://community.powerbi.com/t5/Desktop/Multiple-selection-with-and-logic/m-p/1663300#M664888

To get the cont of filtered products you can use something like this.

Filtered Product Count = 
VAR _FilteredProducts = 
FILTER ( 
    VALUES( 'Table'[Product] ),
    [Product Filter] = 1
)
RETURN 
    COUNTROWS ( _FilteredProducts )

[parry2k]

@IF check this post and I hope it helps.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡