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.

     

edhans's avatar
edhans
Community Champion
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.