Slicer that shows two rows or values

[Anonymous]

Hi, when I create a slicer it has Good and Faulty. But I want the Faulty in the slicer to show only if there are two Faulty in its Product. Don't show if its only one Faulty. Any DAX help is appreciated

[v-yingjl · Accepted solution]

Hi @Anonymous ,

Create this simple measure, put it in the table visual and set its value as 2 in the visual filter:

Count = COUNTROWS('Table')

 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Not very clear,

Use this measure with Product in a visual

countx(filter(summarize(Table, Table[Product],"_1", calculate(count(Table[Product]), Table[Condition] = "Faulty")),[_1] >1),[Product])

[Anonymous]

the slicer didnt work, below is another explanation, when I click on the Faulty, I want to see only those counts are two (exclude the one)