Forum Discussion

lc1's avatar
lc1
Icon for Helper III rankHelper III
2 years ago

Remove duplicates if condition is met

Hello, I have two columns (Project Id) and (Fund). I need to filter only projects that are funded 100% by PTP not partially funded. Can someone advise the best way to obtain these results? Thank ...
Need Help
NaveenGandhi's avatar
NaveenGandhi
Icon for Memorable Member rankMemorable Member
2 years ago

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!!!