Reply
dreynolds
New Member
Partially syndicated - Outbound

count of occurrences of subcategories

We have a category of data that has multiple options, its called doc type and it has options that are dwg, vdwg, sop. I was wondering if there was a way to get a count of how many items are dwg, and how many are vdwg, etc, and what the best way to do it is so that we can take the data and put it in a table. For example it should look like this

 

DWGVDWGSOP
25145245
1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Syndicated - Outbound

HI @dreynolds 
Your scenario sounds very similar to the linked discussion  (i attache there a sample file with solution):

https://community.fabric.microsoft.com/t5/Desktop/Visualization-of-a-multiple-choices-list-in-a-bar-...

Please refer to or provide some sample data and expected output

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

2 REPLIES 2
Ritaf1983
Super User
Super User

Syndicated - Outbound

HI @dreynolds 
Your scenario sounds very similar to the linked discussion  (i attache there a sample file with solution):

https://community.fabric.microsoft.com/t5/Desktop/Visualization-of-a-multiple-choices-list-in-a-bar-...

Please refer to or provide some sample data and expected output

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
ryan_mayu
Super User
Super User

Syndicated - Outbound

could you pls provide some sample data and expected output?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)