DAX expression which will help filter out NON duplicate values

[helen_p]

Dear community

It has been a while since I have needed some support but was wondering if someone could help me with a DAX expression

I will try and highlight the data structure and the aim

Aim:  In a stacked bar chart I wish to show only ID's who have had multiple Care groups.   The visual could look a bit like this

Consideration: I felt that a DAX expression would be useful so I can count the ID's and then filter on that DAX on the visual where the Count is greater than 1 

Data looks a bit like this:

ID              Care Group

12345               A

12345               B

12344               R 

12344               T  

12346               M

12347               P

12367               B

12367               C

The stacked bar chart in this instant should NOT include those patients who only have 1 entry I.e.  12346 and 12347

Kind Regards

Helen

[Anonymous]

Hi @helen_p ,

Try using this measure as a visual filter.

Measure = CALCULATE(COUNT('Table'[Care Group]),ALLEXCEPT('Table','Table'[ID]))

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[tamerj1]

Hi @helen_p 
Please try

=
COUNTROWS (
    FILTER (
        VALUES ( Patients[ID] ),
        CALCULATE ( COUNTA ( Patients[Care Group] ) ) > 1
    )
)