Forum Discussion
Hey folks
I have below table (table A1) I want to get the total of "Number of Failed" repeated in each row of the "fail%ofTotalFail" the variable "Failed%" is the percentage of failed of the "Total Order" 1,2,3,4,5,6,7 rows fail, in other word, the percentage of a category failed, for "fail%ofTotalFail" I want to know what percentage the observation [1, 96027, 7189, 7.49%] and so on makes of the Total "Number of Failed".
fail%ofTotalFail = CALCULATE(SUM(A1['Number of Failed'], ALL())) does not work.
Thanks
Hi MohammadAziz
You can try the following code:
fail%ofTotalFail = CALCULATE(SUM(A1['Number of Failed'], ALL(A1)))
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- jewel_at
Resolver I
try this?
Measure 2 = CALCULATE(SUM('Table'[AllTotalFail]), ALLSELECTED('Table'))Let me know if it works!
Jewel
Hi MohammadAziz
You can try the following code:
fail%ofTotalFail = CALCULATE(SUM(A1['Number of Failed'], ALL(A1)))
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
