Forum Discussion

theschuss's avatar
theschuss
Frequent Visitor
8 years ago

Update calculated column or filter based on slicer?

I have a complex org hierarchy that isn't realistic to turn into a table (would result in something like 2 million+ fields), but would like to use a manager slicer to retrieve all hierarchy members b...
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi theschuss,

Not like measures, calculate columns/tables are computed during database processing.  It is impossible to create a calculate column/table can change dynamically with user selections in the slicer. For more details, please review the answer in this knowledge base.

Thanks,
Angelia

theschuss's avatar
theschuss
Frequent Visitor
8 years ago

Are there any recommended workarounds? 

I know some folks do some interesting stuff with parameters, but was curious if there's any way to do it without changing every measure on the dashboard.