Need help setting up measures for Pareto Analysis of Data

[Anonymous]

I'm trying to implement Pareto analysis in my reports, but am unable to do so.

Specifically, when it comes to cumulative running totals and percentages, I am using the following DAX formula:

CALCULATE(
    SUMX(
        'Ordini Aperti',
        [Importo Consegna]
    ),
    [Rank] < =MAXX('Categorie Articoli', [Importo Consegna]))

 But I'm getting the error "A function 'PLACEHOLDER' has been used in a TRUE/FALSE expression that is used as a table filter expression. This is not allowed.".

As far as I can tell, this is depending on the usage of the [Rank] measure inside the filter expression in my measure.

How should I go about this?

[amitchandak]

@Anonymous , refer

Power BI Window function- Pareto Analysis, 80% of sales, Order by on Measure: https://www.youtube.com/watch?v=UVxiLc_AzSs

https://exceleratorbi.com.au/pareto-analysis-in-power-bi/