Forum Discussion

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