Forum Discussion

wolfy_'s avatar
wolfy_
Helper I
8 years ago
Solved

Find duplicate values diferent projects

Hi,   It is possible to have a measure that find me duplicate values for project IDs in the same location?   For example, there is project ID 1 for the same location Lisbon. The same happens wit...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi wolfy_,

     

    In my opinion, you can calculate count and distinct count of specific project id from same location. Then calculate the diff between them, It should be the duplicate id count.

    Measure =
CALCULATE (
    COUNT ( Table[Project ID] ) - DISTINCTCOUNT ( Table[Project ID] ),
    ALLSELECTED ( Table ),
    VALUES ( Table[Location] )
)

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi wolfy_,

 

In my opinion, you can calculate count and distinct count of specific project id from same location. Then calculate the diff between them, It should be the duplicate id count.

Measure =
CALCULATE (
    COUNT ( Table[Project ID] ) - DISTINCTCOUNT ( Table[Project ID] ),
    ALLSELECTED ( Table ),
    VALUES ( Table[Location] )
)

 

Regards,

Xiaoxin Sheng