Forum Discussion
Dividing two calculated columns
Hello everyone, Recently I started to work with powerBI, and my calculations are not working properly. This is my data; KeyID Process Status A1 A Error A2 A Error A3 A A...
Hi Anonymous ,
Please try:
Column = CALCULATE( SUM([Error])/ SUM([Error & Success]), ALLEXCEPT('Table','Table'[Process]))Or you could create measures instead:
Number of Error = COUNTROWS(FILTER('Table',[Status]="Error"))Number of Error&Success = COUNTROWS(FILTER('Table',[Status] in {"Error","Success"}))% = DIVIDE( [Number of Error],[Number of Error&Success])Output:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Greg_Deckler
Community Champion
Community ChampionAnonymous Shouldn't that last one be:
Number of Error/Number of Error&Status: sum(table[Number of Error]) / sum(table[Number of Error&Status])
Hi Greg thank you for your reply but it is not working either..