Find duplicates

[Slukuleni]

I get tge beklow error on this formula in DAX

The syntax for ')' is incorrect. (DAX(VAR Duplicates = 'Dim GL Account FPA'[Dim GL Account FPA.FPA Account Code])).

Count Duplicates =
VAR Duplicates = 'Dim GL Account FPA'[Dim GL Account FPA.FPA Account Code]
RETURN

CALCULATE(
COUNTROWS('Dim GL Account FPA'),
ALL('Dim GL Account FPA'),
'Dim GL Account FPA'='Dim GL Account FPA'[Dim GL Account FPA.FPA Account Code]

[v-dineshya]

Hi @Slukuleni ,

Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.

[v-hashadapu]

Hi @Slukuleni , Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.

[vivek31]

HI @Slukuleni ,

you can use this formula to find duplicates

Count Duplicates =
VAR Duplicates = 'Dim GL Account FPA'[FPA Account Code]
RETURN
CALCULATE(
COUNTROWS('Dim GL Account FPA'),
ALL('Dim GL Account FPA'), 'Dim GL Account FPA'[FPA Account Code] = Duplicates ) 

[v-hashadapu · Accepted solution]

Hi @Slukuleni , Thank you for reaching out to the Microsoft Community Forum.

Please refer attached .pbix file and see if it solves your issue. If not, please provide details along with sample data.

If this helped solve the issue, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.

[v-dineshya]

Hi @Slukuleni ,

Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.

[bhanu_gautam]

@Slukuleni , Try using

DAX
Count Duplicates =
VAR Duplicates = 'Dim GL Account FPA'[FPA Account Code]
RETURN
CALCULATE(
COUNTROWS('Dim GL Account FPA'),
ALL('Dim GL Account FPA'),
'Dim GL Account FPA'[FPA Account Code] = Duplicates
)