Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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.
@v-stephen-msft No Total_ count_ pass and Total count are calculated column. I am not sure if that make a diffrence.