Filter out ordered projects but also keeping other projects that are not ordered

[gunther15]

Hi,

I have a report that has multiple projects that sometimes have multiple quotes listed on it for sales that are either ordered, pending, won, or lost.  I want to get the data to show only 1 quote per project but include all the ordered quotes to start.  How would I put a filter on this along with keeping all the other projects that do not have a ordered quote.

Thank you

[Anonymous · Accepted solution]

Hi  @gunther15 ,

Here are the steps you can follow：

1. Create calculated column.

Flag =
CONTAINSSTRING('Table'[Merge],"5")

2. Create calculated table.

Table 2 =
FILTER('Table','Table'[Flag]=TRUE())

3. Result:

Best Regards,

Liu Yang

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

[parry2k]

@gunther15 it will be easier if you share some sample data with the expected output.  Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[gunther15]

Here is some saple data, I want to try and keep and all the ones with 5 in first as those are the ordered quotes.  I want to keep the highest quote for the project as well.  The problem I have is some of the ordered ones are not the highest quote value for that project which is why I have multiple quotes for one project.  How would I filter out the non ordered quotes on those specific projects where the highest quote value is not ordered but there is an ordered quote against that project.  And also keep the other projects that do not have an ordered quote against it.