Forum Discussion
Helper ICOUNTIF with multiple columns issue
Hello,
I have a dataset that is connected to Sharepoint and I'm trying to calculate some quality assurance errors.
My dataset is originally as shown with one column for errors "CU Service Errors" where you can see each record can have multiple errors attached to it separated by a comma.
I split the column up into four distinct columns: "CU Service Errors 1,2,3 & 4" as shown below:
So now each column only has one error per cell.
My issue is where to go from here as I need to report on how many of each error we see, by rep, etc. and I thought maybe to group it, but that hasn't worked out - so right now - I'm kind of stuck.
Any thoughts or advice to make this easy?
Sorry - this did work after I tried it again. Much appreciated.
5 Replies
ryan_mayuSuper User
maybe you can select other columns and unpivot other columns
then the errors are in one column
ianallen13Thank you for replying! I did do this per your suggestion, but when I did it, it ran into about 300+ errors that it came up with.
I can split the columns, but is there a way at all, even a DAX formula that would allow me to count the number of specific errors that occur?
- ryan_mayu
a little consfused. could you pls provide some sample data and expected output?
- Ashish_Mathur
Hi,
In the Split window, click on Advanced Options and select rows. This will split the CU Service errors into rows rather than columns.
