count of occurrences of subcategories

[dreynolds]

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

DWG	VDWG	SOP
25	145	245

[Ritaf1983 · Accepted solution]

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

[ryan_mayu]

could you pls provide some sample data and expected output?