I have a quick question about how to ignore the blank values in percentile calculation. I made a very simple virtual table as showed below, where the column ‘Duration’ is a measure. I’d like to calculate the 75 percentile of this measure. So I used :
75 Percentile of Duration = PERCENTILEX.INC(VALUES('Schedule Analytics'[ProjectName]),[Duration],0.75)
There are several blanks in the virtual table, which is fine because the blank means there is no such Duration value for some projects. When I used the formula above to calculate the 75 percentile value, I think it treated blank as zero, so the result is not correct. I used the filters to exclude blank values but still got the same result. What else should I try to fix this?
thanks a lot!