Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to calculate duplicates with exceptions

Hi Community, i have create this formula to calculate the ducpliates in a list: Exampel = VAR varCurrentValue = 'Elements'[Description] VAR varInstances =     COUNTROWS(         FILTER(  ...
Need Help
Idrissshatila's avatar
Idrissshatila
Icon for Super User rankSuper User
3 years ago

hello,

you could add a var at first to specify the the elemets like element <> "car" && element <> "Table" && element <> "house"

 

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos👍

Follow me on Linkedin

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Can you add an example? 
    I do not understand your response


    Regards