Count on the Slicer

[Sudharshan1919]

Hi All,

I am using slicer to filter the options for the page. I am using the below kind of filter.

I need the filter to be modified like below, that is to get the count of that particular meter count beside that filter.

Thanks,

Sudharshan

[Kishore_KVN]

Hello @Sudharshan1919 use below column to get the same 

Meter Slicer = 'Table'[Meter] &" ("&CALCULATE(COUNT('Table'[Meter]),ALLEXCEPT('Table','Table'[Meter]))&")"

Drag this meter slicer into slicer. 

Output looks like this:

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

[Sudharshan1919]

Hi @Kishore_KVN 

Below is the how my data looks like. I have kept the drill through functionality for the Resources Column to see the list of resources that are in the particular ResourceGroup/DeliveryGroup and its respective costs. 

After drill through to one specific one, my drill through page looks like below

So, here are 2 Virtual Machines and 2 Virtual Networks, so in the slicer above, it should the respective counts of the categories. The count must change dynamically, when ever drill through is done and all the count of those respective resources must come beside that.

Thanks

Sudharshan.

[Anonymous]

HI @Sudharshan1919,

Current power bi does not support to create dynamic calculated column/tables based on filter selections. They are work on different level and you can't use the child level to affect its parent.

Notice: the data level of power bi(from parent to child level)

Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

Regards,

Xiaoxin Sheng