Need slicer to display number of items for each slicer value

[Anonymous]

I have what seems like a simple issue, but can't figure it out and can't find it here on the forums. I need my slicer to show how many items are part of each slicer value, and have that number change as filters are applied. I found a partial solution, which shows the total number of items, but it's not responding to filters.

So for example, this shows the number of items for each slicer value in the base data set:

But if I change my date slicer and reduce the size of the data, the numbers on the slicer don't change:

Based on how I designed it (which was based on a thread I found in the user forums), I understand why it doesn't change, it's just counting the base data set, but I can't figure out how to make it dynamic. It can't be too hard, I just don't know my DAX well enough yet. Can anyone please help? .pbix is here: https://drive.google.com/file/d/1GWU9JEDbBJhwaT9thhMGc1jLA8ozjhtu/view?usp=sharing

thanks!

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

The calculated column can not get the slicer value dynamically. Unfortunately, your requirement can't be implemented. There is no workaround after testing.

Best Regards,

Xue Ding

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

[JosefPrakljacic]

I'm afraid that this won't work. I tried it with a calculated table but the slicer is not changing. 

BR,

Josef