Hey folks

[MohammadAziz]

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

[Anonymous · Accepted solution]

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.

[jewel_at]

try this?

Measure 2 = 
CALCULATE(SUM('Table'[AllTotalFail]), ALLSELECTED('Table'))

Let me know if it works!

Jewel