Quartile

[Anonymous]

Hello,

I am struggling to group customers into "Tiers" based on growth potential. The snapshot shows the expected result.

One important thing to note is that measure growth potential (column B) is not located in the same table as customer (column A), it is made of variables from multiple tables and sits in a "measure table". I think that's where I am struggling, i.e., I am not able to create a virtual table like the one in columns A-C and perform the percentiles.

Needless to say, growth potential is dynamic according to filters. 

Many thanks for your help.

[lbendlin]

Power BI has built in DAX functions for this - PERCENTILEX etc.