Forum Discussion

Carlo1975's avatar
Carlo1975
Helper I
5 years ago
Solved

Repeated Values

Hi I have a column with my sell ID. ID 00065862 00035306 00049674 00038281 00036700 00053195 00032684 00078092 00049675 00078095 00048102 00048101 00048103 ...
Need Help
  • edhans's avatar
    edhans
    5 years ago

    You could use a calculated column like this Carlo1975 

    Instance Count = 
VAR varCurrentID = 'Table'[ID]
RETURN
COUNTROWS(
    FILTER(
        ALL('Table'),
        'Table'[ID] = varCurrentID
    )
)

    Same as a COUNTIFS() in Excel.

     

AlB's avatar
AlB
Community Champion
5 years ago

Hi Carlo1975 

If you create a calulcated table with

     ALL(Table1[ID])

the duplicates will already be removed

 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers