Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi All
sorry to ask what must be a simple question.
I have data that is collected by scaning in and out items from a stock. Each time it is scaned in, and then again out a new record is created. In the end i have lots of entireies with the same data but all collected at diffrent times.
I can filter by date and see the movments of items by day but it dose not give me what i need. I would like to count the amount of unquie items that are in my data set. Is there a way i can do this.
Also is it possibel to add a slicer that would filter to only unique values.
Solved! Go to Solution.
Here you go
4 | 0f6f2427-07a9-4f72-8922-38eecdbeb224 | cpowertablet1@gmail.com | 2018-07-01 13:54:51.000 | PPE Kit Bag Check in / Out | 27 | 01.07.2018._Check Out | 0 | NULL | 2018-07-01 13:52:57.000 | 2018-07-01 13:54:51.000 | NULL | 2018-07-01 13:52:57.000 | Check Out | Assigned | Gavin Fisher | CPower Kit Bag 02 | NULL | Harness 40058 | Frog 171918170885 | Work Positioner 20810009 / 032 | Fall Aresst 20814693 / 014 | Life JKT R500304 | NULL | NULL | NULL | Immersion Suite 3841089055 | 2 |
5 | cbaefadb-37bb-46b5-b891-da26043c8825 | cpowertablet1@gmail.com | 2018-07-01 14:00:46.000 | PPE Kit Bag Check in / Out | 27 | 01.07.2018._Check Out | 0 | NULL | 2018-07-01 13:55:04.000 | 2018-07-01 14:00:46.000 | NULL | 2018-07-01 13:55:05.000 | Check Out | Assigned | Jamie Walton | CPower Kit Bag 14 | NULL | Harnress 38780 | Frog 171918171447 | Work Positioner 20745277 / 055 | Fall Arrest 208146938 / 002 | Life JKT R 501822 | NULL | NULL | NULL | Immersion Suite 3841082935 | 2 |
6 | aa8d1c6c-93a6-478a-9e8c-e64e34af08d9 | cpowertablet1@gmail.com | 2018-07-01 14:09:23.000 | PPE Kit Bag Check in / Out | 27 | 01.07.2018._Check Out | 0 | NULL | 2018-07-01 14:01:35.000 | 2018-07-01 14:09:23.000 | NULL | 2018-07-01 14:01:36.000 | Check Out | Assigned | Craig Raffle | CPower Kit Bag 10 | NULL | Harness 39971 | Frog 171918171431 | Work Positioner 20776496 / 037 | Fall Arresst 20797196 / 029 | Life JKT R493848 | NULL | NULL | NULL | Immersion Suite 3841082679 | 2 |
7 | 48f5726d-10c9-484e-8fec-79453029b516 | cpowertablet1@gmail.com | 2018-07-01 14:14:14.000 | PPE Kit Bag Check in / Out | 27 | 01.07.2018._Check Out | 0 | NULL | 2018-07-01 14:09:49.000 | 2018-07-01 14:14:14.000 | NULL | 2018-07-01 14:09:53.000 | Check Out | Assigned | Mark Instance | CPower Kit Bag 1 | NULL | Harness 37331 | Frog 171918171454 | Work Positioner 20732946/098 | Fall Arest 20750662/003 | Life JKT R493849 | NULL | NULL | NULL | Immersion Suit 3841087857 | 2 |
8 | 4acc2081-11d8-4502-b86a-9380841b2bec | cpowertablet1@gmail.com | 2018-07-01 14:34:10.000 | PPE Kit Bag Check in / Out | 27 | 01.07.2018._Check Out | 0 | NULL | 2018-07-01 14:30:13.000 | 2018-07-01 14:34:10.000 | NULL | 2018-07-01 14:30:13.000 | Check Out | Assigned | Anthony Price | Cpower Kit Bag 08 | NULL | Harness 38223 | Frog 171918171085 | Work Positioner 20727089 / 008 | Fall Arrest 20750662 / 006 | Life Jacket R500330 | NULL | NULL | NULL | Immersion Suite 3841089037 | 2 |
9 | 0f068299-e689-428b-97e6-24db79d1ca29 | cpowertablet1@gmail.com | 2018-07-01 14:35:53.000 | PPE Kit Bag Check in / Out | 27 | 01.07.2018._Check Out | 0 | NULL | 2018-07-01 14:34:16.000 | 2018-07-01 14:35:53.000 | NULL | 2018-07-01 14:34:17.000 | Check Out | Assigned | Craig Price | Cpower Kit Bag 11 | NULL | Harness 37332 | Frog 171918171462 | Work Positioner 2072 7089 / 009 | Fall Arrest 2075 0662 / 015 | Life JKT R500302 | NULL | NULL | NULL | NULL | 2 |
10 | 0e506f29-f8e2-4f99-89b3-c977f18edec4 | cpowertablet1@gmail.com | 2018-07-01 14:37:56.000 | PPE Kit Bag Check in / Out | 27 | 01.07.2018._Check Out | 0 | NULL | 2018-07-01 14:36:05.000 | 2018-07-01 14:37:56.000 | NULL | 2018-07-01 14:36:05.000 | Check Out | Assigned | Marc Asif | CPower Kit Bag 04 | NULL | Harness 38225 | Frog 171918171465 | Work Positioner 20727089 / 015 | Fall Arrest 20750662 / 008 | Life JKT R493847 | NULL | NULL | NULL | Immersion Suite 3841082937 | 2 |
11 | 0f068299-e689-428b-97e6-24db79d1ca29 | cpowertablet1@gmail.com | 2018-07-01 14:45:06.000 | PPE Kit Bag Check in / Out | 27 | 01.07.2018._Check Out | 1895328 | NULL | 2018-07-01 14:44:35.000 | 2018-07-01 14:45:06.000 | NULL | 2018-07-01 14:34:17.000 | Check Out | Assigned | Craig Price | Cpower Kit Bag 11 | NULL | Harness 37332 | Frog 171918171462 | Work Positioner 2072 7089 / 009 | Fall Arrest 2075 0662 / 015 | Life JKT R500302 | NULL | NULL | NULL | Immersion Suite 3841082680 | 2 |
12 | 2a977e69-b838-4829-bc26-ec11d4c7af88 | cpowertablet1@gmail.com | 2018-07-03 12:16:14.000 | PPE Kit Bag Check in / Out | 29 | CPower Kit Bag 14_Check inJamie Walton | 0 | NULL | 2018-07-03 12:13:49.000 | 2018-07-03 12:16:14.000 | NULL | 2018-07-03 12:13:49.000 | Check in | Assigned | Jamie Walton | CPower Kit Bag 14 | NULL | Harnress 38780 | Frog 171918171447 | Work Positioner 20745277 / 055 | Fall Arrest 208146938 / 002 | Life JKT R 501822 | NULL | NULL | NULL | Immersion Suite 3841082935 | 2 |
13 | f1842123-5e04-4586-a8da-a326e3925f30 | cpowertablet1@gmail.com | 2018-07-03 12:18:22.000 | PPE Kit Bag Check in / Out | 29 | CPower Kit Bag 1 _Check inMark Instance | 0 | NULL | 2018-07-03 12:16:39.000 | 2018-07-03 12:18:22.000 | NULL | 2018-07-03 12:16:39.000 | Check in | Assigned | Mark Instance | CPower Kit Bag 1 | NULL | Harness 37331 | Frog 171918171454 | Work Positioner 20732946/098 | Fall Arest 20750662/003 | Life JKT R493849 | NULL | NULL | NULL | Immersion Suit 3841087857 | 2 |
14 | b890e44d-f91e-4707-a7f6-203d9210e4aa | cpowertablet1@gmail.com | 2018-07-03 12:24:46.000 | PPE Kit Bag Check in / Out | 29 | CPower Kit Bag 04_Check inMarc Asif | 0 | NULL | 2018-07-03 12:20:02.000 | 2018-07-03 12:24:46.000 | NULL | 2018-07-03 12:20:03.000 | Check in | Assigned | Marc Asif | CPower Kit Bag 04 | NULL | Harness 38225 | Frog 171918171465 | Work Positioner 20727089 / 015 | Fall Arrest 20750662 / 008 | Life JKT R493847 | NULL | NULL | NULL | Immersion Suite 3841082937 | 2 |
15 | 5eec4eaa-52e0-4934-aea5-832d9885ea57 | cpowertablet1@gmail.com | 2018-07-03 12:26:45.000 | PPE Kit Bag Check in / Out | 29 | Cpower Kit Bag 11_Check inCraig Price | 0 | NULL | 2018-07-03 12:24:59.000 | 2018-07-03 12:26:45.000 | NULL | 2018-07-03 12:25:00.000 | Check in | Assigned | Craig Price | Cpower Kit Bag 11 | NULL | Harness 37332 | Frog 171918171462 | Work Positioner 2072 7089 / 009 | Fall Arrest 2075 0662 / 015 | Life JKT R500302 | NULL | NULL | NULL | Immersion Suite 3841082680 | 2 |
16 | a483f66d-bd4c-42f1-8ea2-da8384ef31e3 | cpowertablet1@gmail.com | 2018-07-03 12:29:16.000 | PPE Kit Bag Check in / Out | 29 | Cpower Kit Bag 08_Check inAnthony Price | 0 | NULL | 2018-07-03 12:26:57.000 | 2018-07-03 12:29:16.000 | NULL | 2018-07-03 12:26:57.000 | Check in | Assigned | Anthony Price | Cpower Kit Bag 08 | NULL | Harness 38223 | Frog 171918171085 | Work Positioner 20727089 / 008 | Fall Arrest 20750662 / 006 | Life Jacket R500330 | NULL | NULL | NULL | Immersion Suite 3841089037 | 2 |
17 | 4e7a3873-665d-4d1d-a9f3-2adac68b6381 | cpowertablet1@gmail.com | 2018-07-03 12:29:25.000 | PPE Kit Bag Check in / Out | 29 | CPower Kit Bag 04_Check inMarc Asif | 0 | NULL | 2018-07-03 12:18:30.000 | 2018-07-03 12:29:25.000 | NULL | 2018-07-03 12:18:30.000 | Check in | Assigned | Marc Asif | CPower Kit Bag 04 | NULL | Harness 38225 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
18 | 9ff928ba-026d-47e3-896a-107e0d04237b | cpowertablet1@gmail.com | 2018-07-03 12:34:15.000 | PPE Kit Bag Check in / Out | 29 | CPower Kit Bag 10_Check inCraig Raffle | 0 | NULL | 2018-07-03 12:32:38.000 | 2018-07-03 12:34:15.000 | NULL | 2018-07-03 12:32:39.000 | Check in | Assigned | Craig Raffle | CPower Kit Bag 10 | NULL | Harness 39971 | Frog 171918171431 | Work Positioner 20776496 / 037 | Fall Arresst 20797196 / 029 | Life JKT R493848 | NULL | NULL | NULL | Immersion Suite 3841082679 | 2 |
19 | d1f125e5-7dea-4779-8062-a895f23db4e3 | cpowertablet1@gmail.com | 2018-07-03 12:37:39.000 | PPE Kit Bag Check in / Out | 29 | CPower Kit Bag 02_Check inGavin Fisher | 0 | NULL | 2018-07-03 12:35:39.000 | 2018-07-03 12:37:39.000 | NULL | 2018-07-03 12:35:39.000 | Check in | Assigned | Gavin Fisher | CPower Kit Bag 02 | NULL | Harness 40058 | Frog 171918170885 | Work Positioner 20810009 / 032 | Fall Aresst 20814693 / 014 | Life JKT R500304 | NULL | NULL | NULL | Immersion Suite 3841089055 | 2 |
20 | 7349bbbf-aec7-4946-8b66-b1b82ee25362 | cpowertablet1@gmail.com | 2018-07-04 11:36:44.000 | PPE Kit Bag Check in / Out | 29 | CPower Kit Bag 10_Check OutRob Mackie | 0 | NULL | 2018-07-04 11:33:12.000 | 2018-07-04 11:36:44.000 | NULL | 2018-07-04 11:33:12.000 | Check Out | Assigned | Rob Mackie | CPower Kit Bag 10 | NULL | Harness 39971 | Frog 171918171431 | Work Positioner 20776496 / 037 | Fall Arresst 20797196 / 029 | Life JKT R493848 | NULL | NULL | NULL | Immersion Suite 3841082679 | 2 |
21 | 6a4a3636-abaf-48e2-9101-a80466588db2 | cpowertablet1@gmail.com | 2018-07-04 12:42:32.000 | PPE Kit Bag Check in / Out | 29 | CPower Kit Bag 19_Check OutWilliam Cook | 0 | NULL | 2018-07-04 12:37:18.000 | 2018-07-04 12:42:32.000 | NULL | 2018-07-04 12:37:19.000 | Check Out | Assigned | William Cook | CPower Kit Bag 19 | NULL | Harness 39961 | Frog 171918171467 | Work POsitioner 20810009 / 037 | Fall Arrest 20811932 / 024 | Life Jacket R500330 | NULL | NULL | NULL | Immersion Suite 3841089143 | 2 |
22 | bf997e5f-9508-4607-8bbe-e735756c2435 | cpowertablet1@gmail.com | 2018-07-04 12:47:00.000 | PPE Kit Bag Check in / Out | 29 | CPower Kit Bag 03_Check OutScott Walton | 0 | NULL | 2018-07-04 12:43:02.000 | 2018-07-04 12:47:00.000 | NULL | 2018-07-04 12:43:02.000 | Check Out | Assigned | Scott Walton | CPower Kit Bag 03 | NULL | Harness 39041 | Frog 171918171291 | Work Positioner 20727089 / 003 | Fall Arresst 20750662 / 002 | Life JKT R 501822 | NULL | NULL | NULL | Immersion Suite 3841082646 | 1 |
23 | de71cacd-fee9-4c9c-83a5-d56cb359a30b | cpowertablet1@gmail.com | 2018-07-04 12:50:40.000 | PPE Kit Bag Check in / Out | 29 | CPower Kit Bag 09_Check OutMartin Cosker | 0 | NULL | 2018-07-04 12:49:02.000 | 2018-07-04 12:50:40.000 | NULL | 2018-07-04 12:49:03.000 | Check Out | Assigned | Martin Cosker | CPower Kit Bag 09 | NULL | Harrness 39952 | Frog 171590170086 | WOrk Positioner 20776496 / 025 | Fall Arrest 20804105 / 026 | Life JKT R493849 | NULL | NULL | NULL | Immersion Suit 3841089017 | 2 |
24 | c95d6788-4219-4998-8aa8-9ac060aeb740 | cpowertablet1@gmail.com | 2018-07-04 12:58:47.000 | PPE Kit Bag Check in / Out | 29 | CPower Kit Bag 24_Check OutKarl Glover | 0 | NULL | 2018-07-04 12:55:04.000 | 2018-07-04 12:58:47.000 | NULL | 2018-07-04 12:55:04.000 | Check Out | Assigned | Karl Glover | CPower Kit Bag 24 | NULL | Harness 39968 | Frog 171590170153 | Work Positioner 207764964 / 030 | Fall Aresst 20797196 / 032 | Life JKT R500302 | NULL | NULL | NULL | Immersion Suite 3841088834 | 1 |
25 | d2c771f7-0542-4b12-9293-264a96da63a7 | cpowertablet1@gmail.com | 2018-07-04 13:01:28.000 | PPE Kit Bag Check in / Out | 29 | CPower Kit Bag 07_Check OutStu Macleod | 0 | NULL | 2018-07-04 12:59:07.000 | 2018-07-04 13:01:28.000 | NULL | 2018-07-04 12:59:07.000 | Check Out | Assigned | Stu Macleod | CPower Kit Bag 07 | NULL | Harness 37333 | Frog 171590170032 | Work Positioner 20776496 / 023 | Fall Arrest 20797196 / 003 | Life JKT R493847 | NULL | NULL | NULL | Immersion Suit 3841088783 | 2 |
Hi @Colinu,
Above data model is not readable to us as we are not familiar with your scenario. Please post some dummy data with each column name, but just contains necessary columns. And show us your desired output to help us better understand your requirement.
Regards,
Yuliana Gu
User | Count |
---|---|
120 | |
67 | |
66 | |
57 | |
50 |
User | Count |
---|---|
176 | |
83 | |
69 | |
65 | |
54 |