Detect double duplicate value by entity

[Anonymous]

Hello,

how to calculate in dax the number of identical rows in the name and date columns.

The idea is to be able to display by entity the number of rows having the same value for name and date.

Here for the entity 1 and 2 I must display 2 and for the entity 3 I must find 1.

I thought of concatenating name and date and doing a "distinccount" but it always displays 1 for any entity with a segment.

Thanks a lot.

[VahidDM · Accepted solution]

Hi   

Try to add a column as a "DATENAME" by concatenating name and date, then try this measure:

Measure=
CALCULATE (
    COUNTROWS ( 'Table' ),
    FILTER ( ALL ( 'Table' ), 'Table'[DATENAME] = MAX ( 'Table'[DATENAME] ) )
)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Appreciate your Kudos 

@Anonymous

[ziyabikram96]

https://stackoverflow.com/questions/57603253/counting-consecutive-fails-in-test-results-in-power-bi

follow this i think this will help you