Forum Discussion
What DAX function to use to show quartiles
Hi
I need to show the amount of employee's in each quartile by their pay by gender.
I have gender and amount. I want to be able to show something like the following;
Is there a DAX Function i can use to split my data into quartiles?
thanks in advance.
Hi Anonymous
You refer to the following function.
1.PERCENTILE.EXC(<column>, <k>)
Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
PERCENTILE.EXC function (DAX) - DAX | Microsoft Learn
2.PERCENTILE.INC(<column>, <k>)
Returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive.
PERCENTILE.INC function (DAX) - DAX | Microsoft Learn
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
Hi Anonymous
You refer to the following function.
1.PERCENTILE.EXC(<column>, <k>)
Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
PERCENTILE.EXC function (DAX) - DAX | Microsoft Learn
2.PERCENTILE.INC(<column>, <k>)
Returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive.
PERCENTILE.INC function (DAX) - DAX | Microsoft Learn
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
How do you apply this dynamically to a measure not a column?
- Did you ever figure this one out? I am trying to do the same thing
- lbendlin
Super User
Do we have a solution for this?
I'm trying to do something similar.
