Forum Discussion

SAPpowerbi's avatar
SAPpowerbi
Icon for Helper II rankHelper II
3 years ago
Solved

Duplicate values count column

Hi Team ,   I need duplicate values count in calculated column using Name and business line Column . please find below Example Input - In below table - name is DA and busness line is A , B , C so...
General Comment
Interesting Links
Need Help
Show and Tell
  • johnt75's avatar
    johnt75
    3 years ago

    Try

    Num rows =
CALCULATE ( COUNTROWS ( 'Table' ), ALLEXCEPT ( 'Table', 'Table'[Name] ) )
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

Try

Num rows =
CALCULATE ( COUNTROWS ( 'Table' ), ALLEXCEPT ( 'Table', 'Table'[Name] ) )