Forum Discussion
Count values in column with multiple values
Hi I have a column called Case Category - however, you can choose multiple Case Categories in this column if you want, so you can end up with Data like below for this Column/Field: Cat1;Cat2;...
John01 , One way is to split the column into rows. But not sure you want to opt for that way. Also, that will work for import mode
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
Hi amitchandak - i just figured it out, yeah, I had already split them into separate columns, just couldn't figure out how to add up the columns - in the end, I created separate measures to count categories in each split column first, then I created another measure to add the column measures together. Might not be the tidiest method of doing things but got there in the end.