Forum Discussion
Slicer with SummarizeColumn
I have a FactLosses Table, and a DimAccumulation table.
I have a slicer to choose which accumulation zones im interested in.
Once the user has selected the zones, i want to perform a group by year on the losses and sum the losses into year buckets.
I am using DAX to do this currently.
Table = SUMMARIZECOLUMNS(FactForwardLookingAccumulation[Year], "Losses By Year", SUM(FactForwardLookingAccumulation[Net Loss Our Share Usd]))
Problem is the new table always produces the same result. i.e When i make changes to which accumulation perils should be included it makes no difference.
Can this be done?
1 Reply
Hi dannyh246,
You want to create a new table which changes automatically based on selected value in slicer. It's impossible, because calculate columns/tables are computed during database processing(e.g. data refresh) and then stored in the model, they do not response to user selections on the report. Please refer to this knowledage base: Calculated Column/Table Change Dynamically According to Slicer Selection in the Report.
Thanks,
Angelia
