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

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

You can drag Location and Project ID to the row labels and write this measure

 

=COUNTROWS(Data)

 

Hope this helps.