2016 Excel PowerPivot - PercentRank Formula Question

[James02]

Question:

Can PowerPivot 2016 Percentile functions be conditional? For example: Can it calculate the percentile of a segment of the data, not the whole column?

If so, this is a huge boon for PowerPivot 2016. Rumor has it that the Percentile functions are included in 2016, but trying to determine the functionality of those functions.
Excel 2016: Ten Heartwarming Improvements - PowerPivotPro

Thank you!!
James

 

[scottsen]

I have not played specifically with Percentile in 2016, but I'm just going to go ahead and say "yes" anyway.

Pretend you asked this about SUM(). It also takes a column, eg SUM(Sales[Quantity]).

You can easily adjust what gets SUM()'d by something like:
Total In Cali := CALCULATE(SUM(Sales[Quantity], Sales[Region] = "Cali")

Percentile is no different in this reguard.

 

[James02]

Thank you scottsen. That makes perfect sense. I appreciate the help!!