PERCENTILE.EXC of a measure

[pokeRumpali]

Hi,

I have a Measure. I can plot it as linechart and have additional lines for the 10th percentile,  median, 90th percentile. These lines can have labels.

I would like to have a table displaying the 10th percentile,  median, 90th percentile of the same measure.

PERCENTILE.EXC , PERCENTILE.INC accept a column == not a measure.

How do i do this?

[pokeRumpali]

Thanks for the answer. Found the proper one in the documentation:

PERCENTILEX.EXC(table_name, table_name[measure_name], 0.10)

[Greg_Deckler]

@pokeRumpali This looks like a measure aggregation problem. There are X versions of those functions that you can use.

See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.