Forum Discussion

hipojoel's avatar
hipojoel
New Member
4 years ago

Slicer Value

Is there a way you can add the count in the Filter Pane as part of the Slicer Value? In the Image below, it shows the basic Slicer Value. What I am trying to do is add the count in the Filter...
Need Help
Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

Hi hipojoel ,

 

Create a new column like below and use it slicer:-

Prodct_count =
[Product] & "("
    & CALCULATE (
        COUNT ( 'Table'[Product] ),
        'Table'[Product] = EARLIER ( 'Table'[Product] )
    ) & ")"

 

Output:-

Thanks,

Samarth