Forum Discussion
AnnaMagnusson
Helper I
Helper IPareto 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.
4 Replies
- amitchandak
Super User
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..
Luis_CastonHelper III
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?Have you by any chance found a solution to this? I find myself in the same predicament.
