Forum Discussion

mehlenbae2's avatar
mehlenbae2
Helper II
3 years ago
Solved

How can I filter out changing data?

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...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

     

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.