Remove duplicates if condition is met

Good morning,

As mentioned before, the recommendations provided do not bring the expected results. I appreciate your help.

I wish I could've sent a sample of the file but since it has multiple tables related it is very time consuming to recreate.

However, here is a link I found that might help others with a similar problem:

Solved: Re: If Duplicate Value In Column vs Distinct Occur... - Microsoft Fabric Community

Hi lc1 

Would a measure like this help?

Flag = 
VAR _Proj = MAX( 'Table1'[Proj ID] )
VAR _Table =
    FILTER(
        ALL( 'Table1' ),
        'Table1'[Proj ID] = _Proj
    )
VAR _All = COUNTROWS( _Table )
VAR _PTP = 
    COUNTROWS(
        FILTER(
            _Table,
            'Table1'[Fund] = "PTP"
        )
    )
VAR _Logic = IF( _All = _PTP, 1 )
RETURN
    _Logic

That flag can be used to filter your visual.

Remove duplicates if condition is met.pbix

Hi lc1 

Please use below measure.

PTP=

VAR PTPProjects =

    SUMMARIZE(

        FILTER(

            'table',

            CALCULATE(

                COUNTROWS('table'),

                ALLEXCEPT('table', 'table'[Proj ID])

            ) = CALCULATE(

                COUNTROWS('table'),

                ALLEXCEPT('table', 'table'[Proj ID]),

                'table'[Fund] = "PTP"

            )

        ),

        'table'[Proj ID]

    )

RETURN

    if(SELECTEDVALUE('Table'[Proj ID]) IN PTPProjects,"Ok","")

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

Follow me on LinkedIn!!!

Hi,

Write these measures

Financier count = DISTINCTCOUNT(Data[Fund])

Test = 1*(AND([Financier count]=1,MIN(Data[Fund])="PTP"))

Drag the Test measure to the filter section and apply a condition of 1.

Hope this helps.

Hi lc1 ,

May I ask if the solution mentioned in the link you provided helped you?

Best Regards,
Adamk Kong