Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
the output should be 83.33 for each row.
Solved! Go to 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?
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
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |