Forum Discussion
Count duplicate values using a DAX measure
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
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...
What do you mean to be affected by visual level filters?
What type of iteractions you want to have and expected result.
Regards
Mfelix
My data also includes other fields like Status (Active/Inactive).
An example of the functionality I want would be:
I want to be able to filter the matrix to only include active emplyments and the No. of Employments per PersonID to change.
Make sense?
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
Thanks again!