Getting different measure value while using PERCENTILEX

[Surya9]

I used this measure to get the values 
Percentile Q1 =

var a = SUMMARIZE(tblKPIDetails,tblKPIDetails[Agent name],"Act",[Actual])

var c = PERCENTILEX.INC(a,[Act],0.25)

Return c

and I got the expected output when i am using the card visual but when i use this measure in for the table it's not workin there

the output should be 83.33 for each row.

[v-deddai1-msft]

Hi @Surya9 ,

Please try to use the following measure:

Percentile Q1 =
var a = SUMMARIZE(ALL(tblKPIDetails),tblKPIDetails[Agent name],"Act",[Actual])
var c = PERCENTILEX.INC(a,[Act],0.25)
Return c

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[OwenAuger · Accepted solution]

Hi @Surya9 

On each row of the table, the measure is evaluated with that row's "Agent name" filter applied.

To get the result you want, you can use CALCULATETABLE with the ALLSELECTED() modifier to restore the "overall" filter context of the table, for the purpose of variable a.

I would also suggest using ADDCOLUMNS to create the extended column, and using VALUES instead of SUMMARIZE since you are summarizing by a column in the same table.

The resulting measure would be:

Percentile Q1 =
VAR a =
    CALCULATETABLE (
        ADDCOLUMNS ( VALUES ( tblKPIDetails[Agent name] ), "Act", [Actual] ),
        ALLSELECTED ()
    )
VAR c =
    PERCENTILEX.INC ( a, [Act], 0.25 )
RETURN
    c

 Does this give the expected result?