Forum Discussion
data filtering
Hey everyone,
I have a seemingly simple problem, but I just can't deal with it. We have a table which contains service orders, with a lot of columns, with service order codes, types, names of the workers, posting dates, working times etc. We're trying to filter the rows where the work hours on a day for a worker is less than 1 hour. We can do it when we create a table ordered by the workers' name and with a simple daily date filter using a simple visual level filter(Work hours' value is greater than 1), but of course when we try to create a monthly summarized table, it's not the same, because if we set the same filter, it won't summarize the work hours a day, so it would filter every order which lasted less than an hour.
So, my question is that can we create a measure which summarizes the work hours per day, so we could use a visual level filter which checks whether the work hours a day is less than 1?
(I tried to create a measure with the Calculate and Sum functions, like
Workhour a day = CALCULATE(SUM(Table[WorkHours]);...)
but I didn't know what should the filters be in the Calculate function.)
Thanks in advance,
Andris Szepesy
hey danrmcallister,
Thanks for your answer, I think it is good, just little bit complicated. Someone helped me in my other post, and it seems like that it's working, it's simpler a little bit than your code, take a look at it: https://community.powerbi.com/t5/Desktop/filtering-days/m-p/128948#M54799
7 Replies
You will need to supply some sample data and an example of what your expected output is.
Here's some sample data. The output will be a table, which will show aggregate values, like aggregate work hours for every technician. But, we'd like to filter out from the aggregation those work hours (a day) where work hours<1. So, like in the sample, we wouldn't like to summarize for Name1 the work hours from 01.02 when he worked less than an hour.
So, I am assuming that 1,02 is one hour and 2 minutes or is that .02 of 60 minutes?
Also, on 1.6.17 for Name1 would you want to the 024 Order No but not the 023 Order No or would you would you count those both together because the total is over 1 hour.
