Use slicer with count of item's categories

[bimagty]

Hi, 

I want to use slicer by using count of item's category, here is the table example:

As we see, for Place like AB01 has total 2 bands which are LTE900 and LTE1800 meanwhile BC02 has 3 bands, CD03 has 4 bands, etc..

How can I use slicer to filter i.e. only showing Place with 3 bands (or something like that)?

I already try with 

= countrows(values('Place')

But it still seems wrong.

Really hope and appreciate for your help. Thanks in advance! 

[v-chenwuz-msft · Accepted solution]

Hi @bimagty ,

You can use What if parameter in power bi to change the bands number.

And use this measure to do that.

Measure =
VAR _number =
    SELECTEDVALUE ( 'Band'[Band] )
RETURN
    IF (
        CALCULATE ( COUNTROWS ( 'Table' ), ALLSELECTED ( 'Table'[Band] ) ) = _number,
        1
    )

And put the measure in filter pane on this table visual and set it show itmes which is 1.

Result:

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

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

[tamerj1]

Hi @bimagty 

yes you can create a separate filter table containing the numbers 1, 2, 3, etc. then you filter measure would be

=if ( countrows(values('Place') ) = MAXX ( ALLSELECTED ( FilterTable), FilterTable[Number of Brands] ), 1 )

this measure can be placed in the filter pane and you shall select "is equal" and type 1 as a value then spply the filter.