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.

v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
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.