Solved: Count items appear once

Anonymous · ‎10-22-2022

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 · ‎10-22-2022

Hi @Anonymous ,

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

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

View solution in original post

mangaus1111 · ‎10-23-2022

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 · ‎10-22-2022

Hi @Anonymous ,

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

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

Anonymous · ‎10-22-2022

@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.