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
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

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.