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