Display column based on filter selection

[yidaveding]

Hi,

I have two table visuals (T1 and T2) and a parent/child hierachy. Table 1 displays PARENT and Total Amount. I want table 2 to display either PARENT_Column or CHILD_Column depending on selection in T1. If there is ANY PARENT selection in T1, T2 will display the its CHILDREN column.

The following COLUMN calculation always return FALSE, regardless of selection in T1:

new_column=IF(ISFILTERED(TableName[ColumnName]), PARENT_COLUMN, CHILD_COLUMN)

I know the above formular can work as a MEASURE, but it's not working as a COLUMN.

Thanks,

David

[Greg_Deckler]

@yidaveding - See if this helps: https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-EVERYTHING-measures-axis-legend-titl...

[AllisonKennedy]

Calculated Columns are calculated before the report visuals, and therefore cannot/do not update with slicer and filter selections. You will need to use a measure to get updates based on selection.