Power BI Pareto Formula
08/11/2019 11:17
Metrics:
PercentageIssues = (Pareto[IssuesTotal] / [SubTotalIssues])*100
Pareto_Value = SumX(TOPN([Rank],ALL(Pareto[Equipment]),[Total_Amount]),[Total_Amount])
Rank = RANKX(ALL(Pareto[Equipment]),[Total_Amount])
SubTotalIssues = (CALCULATE(SUM(Pareto[IssuesTotal]),ALL(Pareto))*-1)
Total_Amount = sumx(Pareto,Pareto[IssuesTotal])