Calculating the sum of a count Column

Question

Hello all,&nbsp;&nbsp;I ma having trouble with calcumating the yeild of my table.&nbsp; 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.&nbsp; Help woudl be much appreciated.&nbsp;&nbsp;&nbsp;

anonymous · Answer

Hi&nbsp;Solong&nbsp;,
&nbsp;
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.&nbsp;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])))

&nbsp;
&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;
&nbsp;
&nbsp;

solong · Answer

Anonymous&nbsp; No Total_ count_ pass and Total count are calculated column. I am not sure if that make a diffrence.&nbsp;&nbsp;

Forum Discussion

Calculating the sum of a count Column

2 Replies

Related content

TMDL - calculated column

Total Count in Column

Count- Calculated Column

Day count calculated column

Count calculated columns