Percentile

Hi inascargio ,

You can refer the following links to get it:

By DAX:

powerbi - Calculating percentiles by group in Power BI - Stack Overflow

P10 =
    PERCENTILEX.INC (
        ALLSELECTED ( 'Table'[Area] ),
        CALCULATE ( SUM ( 'Table'[Custom.Peso] ) ),
        0.1
    )

By Power Query:

New Percentiles Transformation in Power Query | Microsoft Power Query

Best Regards

Hi Anonymous ,

thanks for the reply.

I followed the DAX solution and slightly modifiied the approach as follows:

=CALCULATE(PERCENTILEX.INC('Table1  2';[Custom.Peso];0,1); ALLSELECTED('Table1  2'[Custom.Gestore]))

And I managed to get exactly the output I needed (see snapshot below).

Thanks

inascargio