Forum Discussion

delphinecarnet's avatar
delphinecarnet
Frequent Visitor
2 years ago

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...
DAX SUMMARIZE FILTER GROUPBY
talespin's avatar
talespin
Icon for Solution Sage rankSolution Sage
2 years ago

Hi delphinecarnet ,

 

Its a Calculate table, you can't recalculate based on slicer selection.

 

Why don't you simply use "Database" table, it has eveything you need.

Set Column Summarization for "Hours" to Sum.

Drop Employee and Summarize tables.

 

delphinecarnet's avatar
delphinecarnet
Frequent Visitor
2 years ago

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's avatar
    talespin
    Icon for Solution Sage rankSolution Sage
    2 years ago

    hi 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.