Count items appear once

[duc]

Hi 

I have a table with Department and Product ID. I am trying to find a measure to count the Product ID that appears once (as below, only 3456 apear once). 

And then, when I click on visual of department, the table visual will show exactly those product ID appearing once.

Department	Product
A	Product 1
A	Product 2
A	Product 3
B	Product 1
C	Product 4
C	Product 5
E	Product 2
F	Product 6

[mangaus1111]

Yes, it seems to me that it works with filters as well.

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

[mangaus1111 · Accepted solution]

Hi @duc ,

see my pbi file. Let me know if the link does not work.

https://1drv.ms/u/s!Aj45jbu0mDVJiyDZKjw9cPH1kn64?e=SCRxz2

[duc]

@mangaus1111  Thansk for your help. I tried your solution and it works well. May I ask further if it works with Filter as well, since we are adding a calculated column? I am looking for a measure to work with filter.