Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
rohitjmd
Helper II
Helper II

how to categorize in different bucket

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,

 data file

1 ACCEPTED SOLUTION

@rohitjmd ,

 

Create another measures like below:

Respondent Number = 
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Respondent ID] ),
    ALLEXCEPT ( 'Table', 'Table'[App Name], 'Table'[Category] )
)

1.PNG 

 

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.

 

View solution in original post

3 REPLIES 3
v-yuta-msft
Community Support
Community Support

@rohitjmd ,

 

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-7c3a1135acfa60af5f231c2f96d1AppStationLIFESTYLE
857d31c3-be20-4ab0-b70e-34389b0623ae8c760f47e4669f29HiCareTOOLS
59a878c8-7086-4539-897c-f25a98581e2016acb9ef91a78ef2PayPalFINANCE
8a29504f-1e32-47aa-b0e7-63095e9a94166ea936607ed7b48eChild SupportPRODUCTIVITY
8a29504f-1e32-47aa-b0e7-63095e9a94166ea936607ed7b48eDropboxPRODUCTIVITY
23d10ced-0e9a-455a-831b-862734fa4eb32024464d620de7a6Adobe AcrobatPRODUCTIVITY
76bfa0e9-a068-4408-9922-61dae0d1861872fb80f822af845dOneDrivePRODUCTIVITY
857d31c3-be20-4ab0-b70e-34389b0623ae8c760f47e4669f29'Domino''s'LIFESTYLE
0f46c1e6-def2-4595-abaf-fe738ce7ccc51CF34B7C-D057-4047-B110-4C6059B953B8FacebookSocial Networking
1a350f86-8d6a-4ad4-b541-8653016674e7eb8cf0459240c516Secure FolderBUSINESS
c3866aca-2232-465d-82f3-ea8726c9638aced9a13f65a1a9dExcelPRODUCTIVITY
c63353e2-baf5-4aa1-9937-b6000061cba93172de358bc937d5Android AutoAUTO_AND_VEHICLES
c63353e2-baf5-4aa1-9937-b6000061cba93172de358bc937d5Google+SOCIAL
c63353e2-baf5-4aa1-9937-b6000061cba93172de358bc937d5RainbowKeyPERSONALIZATION
8a29504f-1e32-47aa-b0e7-63095e9a94166ea936607ed7b48eSound MeterTOOLS
8a29504f-1e32-47aa-b0e7-63095e9a94166ea936607ed7b48eTolunaSOCIAL
66cc64e3-e745-47cf-a04e-7d439200009427d1b6f916a3f393HearthstoneGAME_CARD
66cc64e3-e745-47cf-a04e-7d439200009427d1b6f916a3f393MessengerCOMMUNICATION
66cc64e3-e745-47cf-a04e-7d439200009427d1b6f916a3f393Samsung InternetCOMMUNICATION
f3d3d13b-0cf3-4b61-a352-49a876dd8a65a5770de1adad0b09Harry PotterGAME_ADVENTURE
371fba9f-111b-4edc-8572-3c1788f90bb61bb15eb461e6acf2'Salsa''s Fresh Mex'LIFESTYLE
a9273dd0-9055-49db-8fe9-1551e9216bf5160b182b4d2ce2f0SnapchatSOCIAL
e1445c28-db2e-452b-99ee-7cc3d0724067778d557c85d20aaaYouiFINANCE
c3866aca-2232-465d-82f3-ea8726c9638aced9a13f65a1a9dSydney & NSW NewsNEWS_AND_MAGAZINES
0787145d-4c3c-4a78-9805-2d0fcc93706c847581fab8476e2dOne Line AdvancedGAME_PUZZLE
8a29504f-1e32-47aa-b0e7-63095e9a94166ea936607ed7b48eSBTVENTERTAINMENT
8a29504f-1e32-47aa-b0e7-63095e9a94166ea936607ed7b48eOneNotePRODUCTIVITY
5281627e-149d-4c30-8262-9d662301a55358fd40c60463b70fAmazon ShoppingSHOPPING
3be34727-042e-40f3-ace7-7c3a1135acfa60af5f231c2f96d1PowerPointPRODUCTIVITY
b5a6e7ac-a2db-4884-b838-9a6e050a5644a7d3fc2c27cd0b5dEnglish Listening SpeakingEDUCATION
f3d3d13b-0cf3-4b61-a352-49a876dd8a65a5770de1adad0b09CommBankFINANCE
691fcb32-5295-40a7-aa94-346f4af6e28107947C0A-F351-4E5E-A034-40875EF58CE2Spotify MusicMusic
c3866aca-2232-465d-82f3-ea8726c9638aced9a13f65a1a9dOneDrivePRODUCTIVITY
7974b0bd-a4a3-426b-95ee-37687ac7f1dfA04B9787-49B0-4091-B82D-9D6AF2069573Spotify MusicMusic
9ce9faa7-ffbd-41a4-a565-ea3ba709a6eb89c53367627e7739EdgeFINANCE
8a29504f-1e32-47aa-b0e7-63095e9a94166ea936607ed7b48eProtractorTOOLS
0f46c1e6-def2-4595-abaf-fe738ce7ccc51CF34B7C-D057-4047-B110-4C6059B953B8NetflixEntertainment
d316fabd-f54f-40ca-b602-064dc36a6114e96dc64262e2d60f7plusENTERTAINMENT
c63353e2-baf5-4aa1-9937-b6000061cba93172de358bc937d5ViewFruitSOCIAL
a750543c-3024-430c-81aa-e6b924e296484c476b424c2390e2Google Play servicesTOOLS
0787145d-4c3c-4a78-9805-2d0fcc93706c847581fab8476e2dWrite on PDFPRODUCTIVITY
e1445c28-db2e-452b-99ee-7cc3d0724067778d557c85d20aaai-SayENTERTAINMENT
1546c587-cdb0-430c-8fc8-6addb735349c2265b512b72f5b9aMessengerCOMMUNICATION
29e303fe-f2e9-4460-b35b-f1c703e3fbffb92114bfa68d0203Pixel ColorENTERTAINMENT
b8767189-ea2f-4a34-98ff-45f9dcb607a1C6D8168E-8E78-4C5A-8644-DFD2DFD075F5YouTube - Watch Upload and Share VideosPhoto & Video
3782f793-8cde-42b6-aab4-f52f14e1ea5715D24C90-DF4C-4651-8EDE-25FBD58D9890InstagramPhoto & Video
908723cd-e6a2-4082-9af0-e30baa8659709961bf6e7afcd5faRaizFINANCE
aff1579e-aca2-4807-8f14-e1ec7d4ac1e752D93782-8A4C-47D1-B0D3-353319409108Wish - Shopping Made FunShopping
3782f793-8cde-42b6-aab4-f52f14e1ea5715D24C90-DF4C-4651-8EDE-25FBD58D9890SnapchatPhoto & Video
dee981bc-9d32-4299-90f6-432544557bc8D7371A1D-083C-4B74-9E8A-6DE7ADB21672Wish - Shopping Made FunShopping
f702703f-b293-4212-a215-0c7dacff0eb4BDD481F0-1585-46EC-8959-543572807692InstagramPhoto & Video
f7dc9555-ada9-4fbe-84b4-475010f3d2803A5950B9-9ECE-4FCF-9BBD-E5ECB91E0023SnapchatPhoto & Video
473c853e-fca3-4827-8cb2-df576a5b7884DDE2C857-5AA5-46F7-9A70-AAE501067CD7Wish - Shopping Made FunShopping
9bcae8c4-a775-4dbd-830a-708fbb77fd6af3861eafdac7a3aaTinderLIFESTYLE
9bcae8c4-a775-4dbd-830a-708fbb77fd6af3861eafdac7a3aaMalwarebytesTOOLS
8d84a8f8-f9e7-4853-8a64-cbe81b9b791fc0a51623563ea424AusPostBUSINESS

 

@rohitjmd ,

 

Create another measures like below:

Respondent Number = 
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Respondent ID] ),
    ALLEXCEPT ( 'Table', 'Table'[App Name], 'Table'[Category] )
)

1.PNG 

 

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.

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.