Class fonction with 2 measures

[bentley32]

Hello all,

I am using the class ()  fonction to create buckets that we can call buckets of amount and to create the buckets i am using the measure X,

My problem is the KPI inside my pivot that have the buckets of amount as a dimension : is a division between X and Y

Sometimes the Y is way different then the X, it means that my bucket will take into account the X and not the Y on the KPI division

and i am getting in my Bucket dimension nulls for the divisions between an X inside the range and a Y outside the Range

this is my code for the bucket : 

DUAL(Replace(Class(X,'<= x <',' - '),Class(X+1))

and the measure used is X/Y

Thanks all for your help, its much needed