Adding a column to count rows associated with specific criteria

[JenWilson]

I have a data table (1st table on the left) in my power BI report that I want to summarize based on the count of "Error Outcomes" from the table (so it would look similar to the one on the right). The yellow section has 4 rows where there were 4 errors; 3 that were fixed and 1 that was tossed. I would like to summarize this data based on the criteria that the "Order#" and "EE#" are the same. Therefore, there would be two rows for order 111; 1 row indicating that there were 3 "Fixed" items and one row where that was 1 "Tossed" item. 

Is there a way to do such as I am asking? 

[Anonymous · Accepted solution]

Hi @JenWilson ,

According to your description, here are my steps you can follow as a solution.

(1) My test data is the same as yours.

(2) We can create a measure.

count of error outcomes = COUNTROWS(FILTER(ALLSELECTED('Table'),'Table'[EE #]=MAX('Table'[EE #]) && 'Table'[order #]=MAX('Table'[order #]) && 'Table'[Error Outcom]=MAX('Table'[Error Outcom])))

(3)We can create a table.

Table 2 = SUMMARIZE('Table','Table'[Name],'Table'[Error Outcom],'Table'[Error Outcome as #],'Table'[EE #],'Table'[order #],"count of error outcomes",[count of error outcomes])

(4) Then the result is as follows.

Best Regards,

Neeko Tang

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

[Anonymous · Accepted solution]

Hi @JenWilson ,

According to your description, here are my steps you can follow as a solution.

(1) My test data is the same as yours.

(2) We can create a measure.

count of error outcomes = COUNTROWS(FILTER(ALLSELECTED('Table'),'Table'[EE #]=MAX('Table'[EE #]) && 'Table'[order #]=MAX('Table'[order #]) && 'Table'[Error Outcom]=MAX('Table'[Error Outcom])))

(3)We can create a table.

Table 2 = SUMMARIZE('Table','Table'[Name],'Table'[Error Outcom],'Table'[Error Outcome as #],'Table'[EE #],'Table'[order #],"count of error outcomes",[count of error outcomes])

(4) Then the result is as follows.

Best Regards,

Neeko Tang

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

[JenWilson · Accepted solution]

Thank you so much. This worked just as I requested! 

[amitchandak]

@JenWilson , Have a measure sum of Error Outcomes. and use that in visual with other columns 

If you want a new table you can use group by in the power query

https://docs.microsoft.com/en-us/power-query/group-by