Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am working on a user data and i have fields like respondent id, device id, Apps installed and category of app. i want to draw a result where i can show number of people with more than 10 apps, 8-10 apps, 7 apps, 6 apps, …. And so on for each category type (category in drop down) and above cuts as bars. to be precise i need to count different apps for a unique respondent id for a category type and depending on the count i should place them in one of the aboe buckets
here is the data link,
Solved! Go to Solution.
Create another measures like below:
Respondent Number = CALCULATE ( DISTINCTCOUNT ( 'Table'[Respondent ID] ), ALLEXCEPT ( 'Table', 'Table'[App Name], 'Table'[Category] ) )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I couldn't download the sample data in your group sharepoint folder. In addtion, you may create a measure using DAX like below:
Count Number = CALCULATE ( DISTINCTCOUNT ( Table[Apps installed] ), ALLEXCEPT ( Table, Table[respondent id], Table[category of app] ) )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
here is the data, could you please suggest how to count no of respondents in mentioned bucket too. -more than 10 apps, 8-10 apps and 1-7 apps.
Respondent IDDevice IDApp NameCategory
3be34727-042e-40f3-ace7-7c3a1135acfa | 60af5f231c2f96d1 | AppStation | LIFESTYLE |
857d31c3-be20-4ab0-b70e-34389b0623ae | 8c760f47e4669f29 | HiCare | TOOLS |
59a878c8-7086-4539-897c-f25a98581e20 | 16acb9ef91a78ef2 | PayPal | FINANCE |
8a29504f-1e32-47aa-b0e7-63095e9a9416 | 6ea936607ed7b48e | Child Support | PRODUCTIVITY |
8a29504f-1e32-47aa-b0e7-63095e9a9416 | 6ea936607ed7b48e | Dropbox | PRODUCTIVITY |
23d10ced-0e9a-455a-831b-862734fa4eb3 | 2024464d620de7a6 | Adobe Acrobat | PRODUCTIVITY |
76bfa0e9-a068-4408-9922-61dae0d18618 | 72fb80f822af845d | OneDrive | PRODUCTIVITY |
857d31c3-be20-4ab0-b70e-34389b0623ae | 8c760f47e4669f29 | 'Domino''s' | LIFESTYLE |
0f46c1e6-def2-4595-abaf-fe738ce7ccc5 | 1CF34B7C-D057-4047-B110-4C6059B953B8 | Social Networking | |
1a350f86-8d6a-4ad4-b541-8653016674e7 | eb8cf0459240c516 | Secure Folder | BUSINESS |
c3866aca-2232-465d-82f3-ea8726c9638a | ced9a13f65a1a9d | Excel | PRODUCTIVITY |
c63353e2-baf5-4aa1-9937-b6000061cba9 | 3172de358bc937d5 | Android Auto | AUTO_AND_VEHICLES |
c63353e2-baf5-4aa1-9937-b6000061cba9 | 3172de358bc937d5 | Google+ | SOCIAL |
c63353e2-baf5-4aa1-9937-b6000061cba9 | 3172de358bc937d5 | RainbowKey | PERSONALIZATION |
8a29504f-1e32-47aa-b0e7-63095e9a9416 | 6ea936607ed7b48e | Sound Meter | TOOLS |
8a29504f-1e32-47aa-b0e7-63095e9a9416 | 6ea936607ed7b48e | Toluna | SOCIAL |
66cc64e3-e745-47cf-a04e-7d4392000094 | 27d1b6f916a3f393 | Hearthstone | GAME_CARD |
66cc64e3-e745-47cf-a04e-7d4392000094 | 27d1b6f916a3f393 | Messenger | COMMUNICATION |
66cc64e3-e745-47cf-a04e-7d4392000094 | 27d1b6f916a3f393 | Samsung Internet | COMMUNICATION |
f3d3d13b-0cf3-4b61-a352-49a876dd8a65 | a5770de1adad0b09 | Harry Potter | GAME_ADVENTURE |
371fba9f-111b-4edc-8572-3c1788f90bb6 | 1bb15eb461e6acf2 | 'Salsa''s Fresh Mex' | LIFESTYLE |
a9273dd0-9055-49db-8fe9-1551e9216bf5 | 160b182b4d2ce2f0 | Snapchat | SOCIAL |
e1445c28-db2e-452b-99ee-7cc3d0724067 | 778d557c85d20aaa | Youi | FINANCE |
c3866aca-2232-465d-82f3-ea8726c9638a | ced9a13f65a1a9d | Sydney & NSW News | NEWS_AND_MAGAZINES |
0787145d-4c3c-4a78-9805-2d0fcc93706c | 847581fab8476e2d | One Line Advanced | GAME_PUZZLE |
8a29504f-1e32-47aa-b0e7-63095e9a9416 | 6ea936607ed7b48e | SBTV | ENTERTAINMENT |
8a29504f-1e32-47aa-b0e7-63095e9a9416 | 6ea936607ed7b48e | OneNote | PRODUCTIVITY |
5281627e-149d-4c30-8262-9d662301a553 | 58fd40c60463b70f | Amazon Shopping | SHOPPING |
3be34727-042e-40f3-ace7-7c3a1135acfa | 60af5f231c2f96d1 | PowerPoint | PRODUCTIVITY |
b5a6e7ac-a2db-4884-b838-9a6e050a5644 | a7d3fc2c27cd0b5d | English Listening Speaking | EDUCATION |
f3d3d13b-0cf3-4b61-a352-49a876dd8a65 | a5770de1adad0b09 | CommBank | FINANCE |
691fcb32-5295-40a7-aa94-346f4af6e281 | 07947C0A-F351-4E5E-A034-40875EF58CE2 | Spotify Music | Music |
c3866aca-2232-465d-82f3-ea8726c9638a | ced9a13f65a1a9d | OneDrive | PRODUCTIVITY |
7974b0bd-a4a3-426b-95ee-37687ac7f1df | A04B9787-49B0-4091-B82D-9D6AF2069573 | Spotify Music | Music |
9ce9faa7-ffbd-41a4-a565-ea3ba709a6eb | 89c53367627e7739 | Edge | FINANCE |
8a29504f-1e32-47aa-b0e7-63095e9a9416 | 6ea936607ed7b48e | Protractor | TOOLS |
0f46c1e6-def2-4595-abaf-fe738ce7ccc5 | 1CF34B7C-D057-4047-B110-4C6059B953B8 | Netflix | Entertainment |
d316fabd-f54f-40ca-b602-064dc36a6114 | e96dc64262e2d60f | 7plus | ENTERTAINMENT |
c63353e2-baf5-4aa1-9937-b6000061cba9 | 3172de358bc937d5 | ViewFruit | SOCIAL |
a750543c-3024-430c-81aa-e6b924e29648 | 4c476b424c2390e2 | Google Play services | TOOLS |
0787145d-4c3c-4a78-9805-2d0fcc93706c | 847581fab8476e2d | Write on PDF | PRODUCTIVITY |
e1445c28-db2e-452b-99ee-7cc3d0724067 | 778d557c85d20aaa | i-Say | ENTERTAINMENT |
1546c587-cdb0-430c-8fc8-6addb735349c | 2265b512b72f5b9a | Messenger | COMMUNICATION |
29e303fe-f2e9-4460-b35b-f1c703e3fbff | b92114bfa68d0203 | Pixel Color | ENTERTAINMENT |
b8767189-ea2f-4a34-98ff-45f9dcb607a1 | C6D8168E-8E78-4C5A-8644-DFD2DFD075F5 | YouTube - Watch Upload and Share Videos | Photo & Video |
3782f793-8cde-42b6-aab4-f52f14e1ea57 | 15D24C90-DF4C-4651-8EDE-25FBD58D9890 | Photo & Video | |
908723cd-e6a2-4082-9af0-e30baa865970 | 9961bf6e7afcd5fa | Raiz | FINANCE |
aff1579e-aca2-4807-8f14-e1ec7d4ac1e7 | 52D93782-8A4C-47D1-B0D3-353319409108 | Wish - Shopping Made Fun | Shopping |
3782f793-8cde-42b6-aab4-f52f14e1ea57 | 15D24C90-DF4C-4651-8EDE-25FBD58D9890 | Snapchat | Photo & Video |
dee981bc-9d32-4299-90f6-432544557bc8 | D7371A1D-083C-4B74-9E8A-6DE7ADB21672 | Wish - Shopping Made Fun | Shopping |
f702703f-b293-4212-a215-0c7dacff0eb4 | BDD481F0-1585-46EC-8959-543572807692 | Photo & Video | |
f7dc9555-ada9-4fbe-84b4-475010f3d280 | 3A5950B9-9ECE-4FCF-9BBD-E5ECB91E0023 | Snapchat | Photo & Video |
473c853e-fca3-4827-8cb2-df576a5b7884 | DDE2C857-5AA5-46F7-9A70-AAE501067CD7 | Wish - Shopping Made Fun | Shopping |
9bcae8c4-a775-4dbd-830a-708fbb77fd6a | f3861eafdac7a3aa | Tinder | LIFESTYLE |
9bcae8c4-a775-4dbd-830a-708fbb77fd6a | f3861eafdac7a3aa | Malwarebytes | TOOLS |
8d84a8f8-f9e7-4853-8a64-cbe81b9b791f | c0a51623563ea424 | AusPost | BUSINESS |
Create another measures like below:
Respondent Number = CALCULATE ( DISTINCTCOUNT ( 'Table'[Respondent ID] ), ALLEXCEPT ( 'Table', 'Table'[App Name], 'Table'[Category] ) )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |