How to use measure value as static variable in other measure

[Anonymous]

Hi,

I have calculated the measure of percentile.inc of the variable distribution "VAR_ADJ" as shown here:

"Percentile = PERCENTILE.INC('Table'[VAR_ADJ],0.99)", to obtain the value "1,7934" (dynamic value according to the filters).

If I put the percentile in a visualization table, I obtain the "VAR_ADJ" distribution as values in rows and the percentile (1,7934) in the total row.

What is the correct method in order to obtain a formula, where can I divide the values of my row ALWAYS by the same value (i.e. the PERCENTILE value as fixed)?
And not get a line-by-line division like in the following example (...)

DIVIDE('Table'[VAR_ADJ]/Percentile) --> DIVIDE(2,0476/1,7934) and DIVIDE(2,0338/1,7934) ecc...

and not DIVIDE(2,0476/2,0476) or DIVIDE(2,0338/2,0338) ecc...

Thanks a lot!

[Greg_Deckler]

@Anonymous This looks like a measure aggregation problem. 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.