Forum Discussion

JenWilson's avatar
JenWilson
Icon for Helper II rankHelper II
3 years ago
Solved

Adding a column to count rows associated with specific criteria

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). Th...
  • Anonymous's avatar
    Anonymous
    3 years ago

    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's avatar
    JenWilson
    3 years ago

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