Forum Discussion
Count items appear once
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 |
Hi Anonymous ,
see my pbi file. Let me know if the link does not work.
https://1drv.ms/u/s!Aj45jbu0mDVJiyDZKjw9cPH1kn64?e=SCRxz2
3 Replies
Hi Anonymous ,
see my pbi file. Let me know if the link does not work.
https://1drv.ms/u/s!Aj45jbu0mDVJiyDZKjw9cPH1kn64?e=SCRxz2
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.
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.