Calculating the sum of a count Column

Hi Solong ,

It's the Power Query forum. But the screenshot provided appears to be present in Power BI Desktop.

And the [Total_pass_count] and the [Total_count] are columns, right?

Here're 2 solutions. One is implemented in PQ and the other is implemented using DAX.

In Power Query:

1.Group by as follows.

2.Expand it.

In Power BI Desktop, using DAX:

Create a calculated column.

Column = CALCULATE(SUM('Table'[Total_count_pass]),FILTER('Table',[Total_count]=EARLIER('Table'[Total_count])))

Best Regards,

Stephen Tao

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