- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Count Across Multiple Columns
Hi everyone,
I'm new to Power BI and having some difficulty doing some analysis:
I want to be able to create a filter of the managers name, that when i select a manager, their top three error codes will be returned.
If there is more than one error listed in "Transaction error code" , the column "Error code for analysis" is multiple, and the errors are split up in the columns "Error code for multiple 1...N"
their are 7 error codes in total:
K1 - incorrect invoice amount entered
K2 - incorrect customer name entered
K3 - incorrect dates entered
L1 - customer account no longer exists
L2 - customer didnt submit all documents
M1 - manager approval pending
M2 - other
Here is my dataset:
Here is our expected output :
Thank You!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
You may download my PBI file from here.
Hope this helps.
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Would you be OK with a 3 column layout of your final output - Name, Type of error and error count?
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hey @Ashish_Mathur !
that could work, but would that mean that the 2nd and 3rd most frequent errors would be on their own rows? ideally all three would be listed in the same row to be more visually appealing
thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Yes, they would be on their own rows. Would you be OK with that?
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Share the link from where i can download your Excel file.
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
I cannot interpret row 2. There are 2 types of errors - K2 and M2 but the count is 3. So does that mean that there are 3 errors each for K2 and M2 or is it split as 2 and 1? So is the ase with rows 9 and 10.
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hey!
thats my mistake when entering the values. Row 2 should say 2 errors and row 9 should say 1 error.
Thanks for pointing that out!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
You may download my PBI file from here.
Hope this helps.
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You are welcome.
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
11-14-2023 08:05 PM | |||
07-30-2024 10:24 PM | |||
09-08-2024 05:27 PM | |||
05-29-2024 11:32 AM | |||
09-19-2024 07:52 AM |
User | Count |
---|---|
141 | |
112 | |
83 | |
63 | |
47 |