How can I filter out changing data?

[mehlenbae2]

Hi everyone,

In my current dataset I have a filter that I use to look at our metrics in 2 ways:

-Tickets breached by everyone in department

-Tickets breached by people only in our assignment groups

I have a column called "Breached by Assignment Group" which I use to filter out assignment groups that are not in our work group. I duplicated the datasets, one for tickets breached only in our work group (which is filtered by only breached assignment groups in our work group) and another for all tickets closed. Both datasets have a custom column called "table type" which has text saying "Breached by all groups" and for the other dataset "Breached by our group".

For example, I filter out "ServiceDesk" and "Procurement" as they are not part of our IT groups.

I have MTD data that comes from a data source every morning and night that is automated to be put in a file on my computer which Power BI grabs and refreshes. The problem is, when the month is over sometimes there isn't any tickets closed from assignment groups outside of our work group so I have to go in and filter those out every month. Is there a easier way to have tickets breached by just our group show and filter out breached tickets by other groups without going in and manually filtering them out in my "Breached by our group" dataset??

[Anonymous · Accepted solution]

Hi @mehlenbae2 ,

As far as I know, you just need to filter all types not in your group in "Breached by Assignment Group" column. Then Power BI will always remove these types after updating data.

As below code, add all types not in your groups in list like "Procurement"/"ServiceDesk"/"xxxx". 

= Table.SelectRows(#"Changed Type1", each not(List.Contains({"Procurement","ServiceDesk","xxxx"},[Breached by Assignment Group] )))

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.