How to calculate duplicates with exceptions

Question

Hi Community,i have create this formula to calculate the ducpliates in a list:Exampel = VAR varCurrentValue = 'Elements'[Description]VAR varInstances = &nbsp; &nbsp; COUNTROWS(&nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Elements',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Elements'[Description] = varCurrentValue&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; )var Result = &nbsp; &nbsp; IF(&nbsp; &nbsp; &nbsp; &nbsp; varInstances &gt; 1,&nbsp; &nbsp; &nbsp; &nbsp; "No",&nbsp; &nbsp; &nbsp; &nbsp; "Yes"&nbsp; &nbsp; )RETURN&nbsp; &nbsp; Result&nbsp;however i would need to exclude some exception in the list for example : house, car and table&nbsp;Can you help me with this??

idrissshatila · Answer

hello,you could add a var at first to specify the the elemets like element &lt;&gt; "car" &amp;&amp; element &lt;&gt; "Table" &amp;&amp; element &lt;&gt; "house"&nbsp;If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos👍Follow me on Linkedin

freemanz · Answer

hi&nbsp;&nbsp;&nbsp;Anonymous&nbsp;try like:Exampel =&nbsp;VAR varCurrentValue = 'Elements'[Description]VAR varInstances =&nbsp;&nbsp;&nbsp;&nbsp;COUNTROWS(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FILTER(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Elements',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Elements'[Description] = varCurrentValue&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;)var Result =IF(&nbsp; &nbsp; NOT&nbsp;varCurrentValue in {"house", "car", "table"},&nbsp;&nbsp;&nbsp;&nbsp;IF(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;varInstances &gt; 1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"No",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Yes"&nbsp;&nbsp;&nbsp;&nbsp;), "No")RETURN&nbsp;&nbsp;&nbsp;&nbsp;Result

anonymous · Answer

Thanks,I forgot to say that that valus must "contain" as i will have many Houses ( house 1, House 3, House 19...)&nbsp;

anonymous · Answer

Can you add an example?&nbsp;I do not understand your responseRegards

Forum Discussion

How to calculate duplicates with exceptions

4 Replies

Related content

Duplicate ranking

remove duplicate value within a row

Removing Duplicates

ERROR: ValidateWorkspaceOACAsync: exception occured

Remove Duplicates Except 0