Pareto chart with Parameters

[AnnaMagnusson]

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.

[RoSch]

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

[Luis_Caston]

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?

[amitchandak]

@AnnaMagnusson , 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

[AnnaMagnusson]

@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..