Slicer Value

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

Hi,can use this :

1.Build a table and connect the relationships :

Fruits = VALUES('Sheet1'[fruit])

2.Re-create columns :

Filter = 'Fruits'[fruit] & "(" & CALCULATE(COUNT(Sheet1[fruit]),ALLEXCEPT(Fruits,Fruits[fruit])) & ")"

 

Thank you for the response.

Now for the tricky part.

The image below shows the fruit Product are then filtered by Customer ID and now the Filter Pane shows the count for each type of fruits changed.

How can I get the number change to show the same count in the Filter Pane, so it would show as

Apples (1)

Grapres (1)

Oranges (1)

Pears (1)

So the count will dynamically changed based on the filtered Customer ID 

That's what I'v read during my research. 

Thank you for time and effort, appreciate it very much.