Quartile Ranking Dynamically

[Anonymous]

I am trying to apply dynamic quartile ranking from measures not from created column values as most of the tutorials suggest. Is it possible to have a measure (e.g. TOTAL_AMT)  and apply a generic Quartile secondary measure over it? So when we filter by any column dimension we can get quartile qualifications based on the recalculated TOTAL_AMT? 

Thanks 

[v-yuta-msft]

@Anonymous ,

I'm afraid this can't be achieved, you need to convert the measure [TOTAL_AMT] to calculate column.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks. That wont work as the Total_AMT is filtered as this example. Do you know why MS wont let you have a dynamic ranking system? Each measure changes so too should the IQR

[v-yuta-msft]

@Anonymous ,

This requirement depends on your specific senario. If you could share sample data and give the expected result, I can do further analysis on it.

Regards,

Jimmy Tao