Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Pareto chart with Parameters

Hi!

 

Is it possible to create a Pareto line with a Parameter?

The examples I've read to get the cumulative sum is always using ALLSELECTED(), but I can't use a Parameter within that.

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Anonymous , what do you mean by parameter? I have used the Numeric parameter here.

    refer if this can help

    Power BI Window: Pareto Analysis Again, 80% of sales, are Order by Measure when REL position is used: https://youtu.be/GpoITi_tRIw

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      amitchandak, I'm using field parameters, so the user is able to select the desired category (x axis) themselves in the chart eg. product line, product, customer..

  • Luis_Caston's avatar
    Luis_Caston
    Icon for Helper III rankHelper III
    2 years ago

    Dear all,

    I'm looking for the same:

    I've a paremeter field:

    Parámetro = {
        ("Cliente", NAMEOF('Cliente'[Cliente]), 0),
        ("FamiliaSuperior", NAMEOF(Articulo[FamiliaSuperior]), 1),
        ("Artículo", NAMEOF(Articulo[Articulo]), 2),
        ("CodArticulo", NAMEOF(Articulo[CodArticulo]), 3)
       
    }

    And I 've this:

    IF I insert the paremeter field at the arrows I obtain the next error:

     

    Calculation error in measure [Net Count ABC]: Column [Parameter] is part of composite key, but not all columns of the composite key are included in the expression or its dependent expression.

    Do you know how to do it?
  • RoSch's avatar
    RoSch
    Frequent Visitor
    1 year ago

    Have you by any chance found a solution to this? I find myself in the same predicament.