Forum Discussion

bullius's avatar
bullius
Helper V
8 years ago
Solved

Count duplicate values using a DAX measure

Hi   I have data that looks like this:   EmploymentID PersonID 1 A 2 A 3 B 4 C 5 D 6 E 7 F 8 G 9 G 10 G   I want to count how many employments eac...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi bullius,

     

    Add you columns to the all except.

     

    The new measure would be something like this:

     

    Measure = CALCULATE( COUNT(Table1[PersonID]), ALLEXCEPT(Table1,Table1[PersonID],Table1[status]))

    as you can see below the top half is raw data and measure without interacting with slicer, bottom part table is filter by status B

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Super User
8 years ago

Hi bullius,

 

Use the following measure:

 

N.º Employments  =
CALCULATE ( COUNT ( Table1[PersonID] ), ALLEXCEPT ( Table1, Table1[PersonID] ) )

Regards,

MFelix

bullius's avatar
bullius
Helper V
8 years ago

Thanks MFelix, 

 

I created a matrix with the measure in the values bucket, but it does not seem to be affected by visual level filters...