Forum Discussion

LorenzoNieri's avatar
LorenzoNieri
Frequent Visitor
5 years ago
Solved

Dynamic pareto measure

Hello, I was thinking about Pareto charts/visuals and percent of total in a perspect of dynamics usage for the user. Here is what I mean: Currently, following Matt Allington blog, I found this for...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi LorenzoNieri ,

     

    Based on your description, I did a test though not very clear to your request. I create a measure as follows.

    test for pareto = 

    var x1=SUMX(FILTER(ALL(tEST),[customer_name]=SELECTEDVALUE('tEST'[customer_name])),[Sales])

    var x2=CALCULATE(SUM('tEST'[Sales]),ALL())

    return

    DIVIDE(x1,x2)

    Result:

    Is the result what you want?

     

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

LorenzoNieri's avatar
LorenzoNieri
Frequent Visitor
5 years ago

Hello and thanks for the reply,

 

It will still depend on that Customer table, if the user changes the dimension into (for instance product) it will display wrong values...