How to remove rows based on conditions

Hi Anonymous 

as you have a requirement "If it is approved and not apporved both then only one row with approved status" try a calculated table

Table = SUMMARIZE('Table1';
Table1[Strategy name];Table1[Value];"Approval Status";MIN(Table1[Approval Status]))

do not hesitate to give a kudo to useful posts and mark solutions as solution

Sorry Anonymous 

Some modification required in DAX.

Hi Anonymous ,

You can try the following methods:
1. As some previous responses, first, remove Duplicates in the Query Editor.

2. Then go back to the Data View and create the calculated column as follows:

Column =
Test[Approval Status] = "Not Approved"
    && CALCULATE (
        MIN ( Test[Approval Status] ),
        ALLEXCEPT ( Test, Test[Strategy name] )
    ) = "Approved"

3. Filter values in the calculated column that are equal to False:

Here is a demo, please try it:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/Ea9CbtwjxyNFp2tCMhjtBFEB0YTYjOYE4G-3sZhGv4bNmA?e=2PNDNT

Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.