Forum Discussion

3 Replies

  • Kishore_KVN's avatar
    Kishore_KVN
    Solution Sage
    3 years ago

    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's avatar
      Sudharshan1919
      Helper III
      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 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