Enable user to have the flexibility to view selected columns to restrict the overall table size.

[Anonymous]

Hi Mirosoft,

Enable user to have the flexibility to view selected columns to restrict the overall table size.

I have two values Dynamic G and Dynamic G %. I have selected  Dynamic G column. Now, data appears for Dynamic G. But as soon i select the required filed ie., Dynamic G, the other column which was unselected ie., Dynamic G % should disappear from the below image. 

Need DAX help  inorder to achieve that dynamically.

[amitchandak]

@Anonymous , You have to create a calculation group for that

calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/

Calculation groups
https://docs.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallproducts-allversions#limitations