Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Third quartile function does not give the correct value

Hi everyon   i have been trying to solve this problem but I could not, i hope someone has faced the same problem.   I have multiple Tables, the important ones are: KPI_fact Hospitals    KPI_f...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

    Please refer to my pbix file to see if it helps you.

    Create a measure. 

    Measure = CALCULATE(PERCENTILEX.INC(Sheet1,[Actvalue],.75),FILTER(ALL(Sheet1),Sheet1[ICD10_PrincipalDiagnosisKey]=SELECTEDVALUE(Sheet1[ICD10_PrincipalDiagnosisKey])))

    If I have miunderstood your meaning, please provide your desired output.

     

    Best Regards

    Community Support Team _ Polly

     

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

     

Whitewater100's avatar
Whitewater100
Icon for Solution Sage rankSolution Sage
4 years ago

Hello:

If you share your data model it will be easier to answer.

 

If you create this for each quartile:

Q3 = (PERCENTILEX.INC(
ALL ('KPI_fact'[IDofdiagnosis]),
[ActualValue ],
0.75                                 other versions  >>>.25, .5 
))
 
You can aslo try this version, applied to yuor data :
Customer Sales 25th Percentile 2 =
PERCENTILEX.INC (
FILTER(
Customers,
NOT ISBLANK([Sales Amount] )
),
[Sales Amount],
.25
)