amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Dynamic Segmentation/ Bucketing/ Binning

Dynamic Segmentation/ Bucketing/ Binning   Created an independent bucket Table. Create measures that take advantage of those buckets   Actual Measure  Margin % = DIVIDE([Margin],[Sales])...
Mathematical
Totals
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Amit,

 

I have followed this and getting below result which is incorrect:

Total is correct but it is not segregating according to buckets.

Till here its fine, 

 

But as soon as I add Measure as below it only gives total but does not segregate

 

My Measure is below:

Age Bucket = COUNTX(filter(VALUES(TrusteeClaimsList_Decision[PolicyCaseBenefitKey]),[Age of Pending Claims] >=Min('Age_Pending_Bucket Table'[Start Limit]) && [Age of Pending Claims] <=max('Age_Pending_Bucket Table'[End Limit])),TrusteeClaimsList_Decision[PolicyCaseBenefitKey])
 
 
Can you please help, it should be as below: