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

I'm not clear on your requirements exactly Carlo1975 , but you cannot just check a few items to answer that specific question. Power BI, either in Power Query or DAX, will check the entire dataset based on the formula you use.

Carlo1975's avatar
Carlo1975
Helper I
5 years ago

Ok, I understand, ans so, more simple. I have to add a column and check when a Id is repeated. Like if in exel i use CountIf