Forum Discussion
Third quartile function does not give the correct value
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.
Hi Anonymous ,
Since your data is rather vague, I recreated a simple sample. Please refer to my pbix file to see if it helps you.
My measure formula is
Measure =
VAR _a =
SUM ( 'Table (2)'[Numerator] )
VAR _b =
SUM ( 'Table (2)'[denominator] )
RETURN
DIVIDE ( _a, _b )
this is the table after adding the Third Qurtile measure.
Measure2= PERCENTILEX.INC(ALL('Table (2)'),[Measure],.75)
If I have misunderstood your meaning, please provide your pbix file without privacy information and 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.
Can't thank you enough.
i provided pbix file so you can understand my problem.
when i change dignosis id its give me the same result of Q3.
i want it to consider the filter
it should see the filter then do the Qalqulation.
I want the process to be as follows:
the filter is applied and then the third ŁQurtile of the data that appeared after the filter is calculated. The Q-value must be one Q-value for all filtered data. In short, I want to see the third Qurtile for each diagnosis-id I choose.
here is the file
Hi:
I have this so far.
https://drive.google.com/file/d/1JGQKQxFTFkllOCFciQNeFE7xNljaUd14/view?usp=sharing
But the third quartile is against all the values. Is that what you are looking for or for each diagnosis the third quartile? Many diagnosis look to have low entries. I hope this helps!
