Forum Discussion
Data filtering problem with slicer
Hi everyone, I have a data table: I need to perform KPI for Organization, Team and every employee, KPI of Team is the data of the employees in the team, KPI of Organization is the data of all...
I may not be reading this correctly but it sounds like you are trying to create a dynamic table based upon user interaction. This simply is not possible. Data tables are calculated only at the time of data load (refresh).
Hi Greg_Deckler, I just want to calculate based on the data loaded, every time Hierachy Slicer is selected, the value will change accordingly. I can do this on each Measure, but it doesn't work when I use a table to save the calculated KPI data.