Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Detect double duplicate value by entity

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.

 

 

Need Help
  • VahidDM's avatar
    VahidDM
    4 years ago

    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

2 Replies