Calculate Percentile from measure

[Zullen17]

Hi, I have a problem with the calculate about percentile 80 and 20 from measure.

This is my table:

Transaction	USER ID
A.1	B.1
A.2	B.2
A.3	B.3
A.4	B.4

Measure: A/B

I need to calculate the percentile 80 and 20 from A/B, and be able to graph it on a line chart over time.

I tried with this:

_max_y__axis =
VAR TableCalculated = SUMMARIZE(TableName, TableName[A], TableName[B], "A/B", DIVIDE(SELECTEDVALUE(TableName[A]), SELECTEDVALUE(TableName[B])))

RETURN PERCENTILE.INC([A/B], 0.8)

But I couldn't beacause I don't have a column, only a measure.

I'll appreciate your help.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...