Forum Discussion

abrasington's avatar
abrasington
Regular Visitor
8 years ago
Solved

Flagging duplicate fields

Hi all,   I have a table with every row describing a single quantity of different types of equipment. Some rows are meant to have a unique item ID code, and I would like to first display all rows ...
Need Help
  • v-xjiin-msft's avatar
    v-xjiin-msft
    8 years ago

    Hi abrasington,

     

    In your scenario, did you mean this?

     

    We can create a calculated column to count the number of ItemID based on equipment type group. And if the number is more than 1, obviously there exists duplicate item id.

     

    Count ItemID =
CALCULATE (
    COUNT ( equipment[ItemID] ),
    ALLEXCEPT ( equipment, equipment[equipment] )
)

     

    And if you want to check a certain type of equipment. You can do this:

     

    Count A1 =
CALCULATE (
    COUNT ( equipment[ItemID] ),
    FILTER ( equipment, equipment[equipment] = "A1" )
)

    Thanks,
    Xi Jin.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

My immediate thought is you could create a calculated column that does a count of each row and how often a particular field appears. You could then filter on that number.

 

Something like 

AppearCount = VAR searchStr = [YourField]
RETURN
Calculate(
         COUNTROWS('MyTable'),
         'MyTable'[YourField] = searchStr
)