topic Re: Hey folks in DAX Commands and Tips

Hey folks

MohammadAziz — Thu, 05 Jan 2023 23:40:53 GMT

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

Re: Hey folks

jewel_at — Thu, 05 Jan 2023 23:55:36 GMT

try this?

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

Let me know if it works!

Jewel

Re: Hey folks

Anonymous — Fri, 06 Jan 2023 03:06:55 GMT

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.