Hi,
I have three columns in one 'EMP' table. Those are 'Manager_Name', 'Salary', 'Other_Expence'.
I have a drillthrough report with these columns, 'Team_Memers', 'Amount'.
I need to drillthrough using 'Salary' & 'Other_Expence' columns. If I drillthrough using 'Salary' then the drillthrough report need to show the values from 'Salary' in 'Amount' column and If I drillthrough using 'Other_Expence' then the drillthrough report need to show 'Other_Expence' in the same 'Amount' column. How to write DAX measure to achieve it?
I am taking both Salary & Other_Expence columns in drillthrough filters. But below DAX expression is not working for 'Other_Expence'
Amount Drillthrough =
VAR SelectedColumn =
SWITCH (
TRUE (),
ISFILTERED ( EMP[Salary] ), SELECTEDVALUE ( EMP[Salary] ),
ISFILTERED ( EMP[Other_Expence] ), SELECTEDVALUE ( EMP[Other_Expence] ),
BLANK ()
)
RETURN
SelectedColumn
