Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Count on the Slicer

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

 

 

data protection
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

3 Replies

  • Kishore_KVN's avatar
    Kishore_KVN
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Hello Anonymous 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!!

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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's avatar
        Anonymous
        Not applicable
        3 years ago

        HI Anonymous,

        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