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

Hi:

3rd Quartile KPI =

VAR ThirdQuartile = [Q3]
RETURN
IF ([Actual Value] = ThirdQuartile, "Q3",
"-")
You can substitute "1" where I have "Q3"
 
I hope this is what you are looking for!
)
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    thank you for your response. 

    the problem is in the third qurtile value. the value is not correct. i think the measure read another data not same data in the table. try to calculate the values in the table manully and find the thirdQ. you will find it wrong.