jeudi 7 février 2019

Create a perato chart in power bi

Is there a way to create a pareto chart

Range = Var Ranked = RANKX(All(Products[Name]), CALCULATE(sum(Products[Cost]))) return Switch(TRUE(), Ranked <= 10, "TOP 10", Ranked <= 20 && Ranked > 10, "TOP 11-20", "OTHERS")

Products Spend = VAR oneVal = If(SELECTEDVALUE(ParetoRange[Range]) = "TOP 10",CALCULATE(sum(Products[Cost]), Filter(All(Products[Name]),[Range] = "TOP 10")),Blank()) VAR twoVal = If(SELECTEDVALUE(ParetoRange[Range]) = "TOP 11 - 20",CALCULATE(sum(Products[Cost]), Filter(All(Products[Name]),[Range] = "TOP 11 - 20")),Blank()) VAR restVal = If(SELECTEDVALUE(ParetoRange[Range]) = "OTHERS",CALCULATE(sum(Products[Cost]), Filter(All(Products[Name]),[Range] = "OTHERS")),Blank()) RETURN SWITCH ( SELECTEDVALUE ( 'ParetoRange'[Range] ), "TOP 10", oneVal, "TOP 11 - 20", twoVal, restVal )

Aucun commentaire:

Enregistrer un commentaire