Calculating the sum of a count Column

[Solong]

Hello all, 

I ma having trouble with calcumating the yeild of my table.  I would liek to calculate the yeild of Sum of Total_pass_count by the Total count. When i go and graph the total counts it shows the total sum that pass. But i can get **bleep** to calculate the sum of total pass per lot number by the total strip count.  Help woudl be much appreciated. 

[v-stephen-msft]

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.           

[Solong]

@v-stephen-msft  No Total_ count_ pass and Total count are calculated column. I am not sure if that make a diffrence.