Forum Discussion
SUMMARIZE with dynamic filter from another table
Hi PowerBI Community! I have a table detailing employees hours in a day (work, travel, day). I created a SUMMARIZE table to calculate the total number of hours per day per employee but I would li...
Because, ultimately I'd like to filter the number of days employees go over a certain number of hours per day: I would like the possoibility to exclude "Break" (the real data split the time in many more types)
talespin
Solution Sage
Solution Sagehi delphinecarnet ,
You can do all this using original table, no measure/calculate table/column required.
Also Calculate Tables/Calculated columns are updated during refresh time, they are not influenced by slicers.