Bucket Dynamic Aging created by Measure

[Anonymous]

Hi community,

hope someone can lead me into the proper direction on this question.

I'm working on a project to display aging of units within a selected timeframe and I would like to dynamically display the aging of them in visuals like a pie-charts or clustered column chart split by total inventory Value or Quantity.

What I have so far working:
Dynamic aging calculation based on the selected slicer timeframe (Reporting Period).
When a user is e.g. selecting the month of November the inventory aging is displayed as of november, or when he/she selects October it's also displayed correctly.
All this is achieved with dynamic measures - there is no helper column or similar.

Now I have created an additional measure based on the age of the item. E.g.: an Item that's at the selected timeframe 7 months old will be calculated by the measure "<12" which is perfect.  Measure "ITM_Aging_Cluster"

My measure for the age classification has multiple values e.g.: "< 12", "12 - 15", "15 - 18", "18 - 24" etc.
Ideally I would love to display this information also grouped based on the quantity or value amount of the items. 
Unfortunatley I can't use a measure as legend within a visualisation but this is exactly what I need and I don't want to use a column as I would loose the opportunity to jump back in any point in time to see the historic aging (I don't/wont have aging tables).

View of the data available

[amitchandak]

@Anonymous , You need to use binning or bucketing using an independent table

example

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

[Anonymous]

HI Amit,

Thank you for the links (I watched your video already couple of times 🙂 ) 

I was following your guide but unfortunatly my buckets stay empty or they display only 1. 

Here is my meseaure 

A_TESTBUCKETS = COUNTX(filter(VALUES('Inventory Transactions_V'[Item No]),[ITM_EQ_Aging] >=MIN('2_tbl_aging_helper'[StartValue]) && [ITM_EQ_Aging] <max('2_tbl_aging_helper'[EndValue])),'Inventory Transactions_V'[Item No])

For full visibility my dynamic aging measure:

ITM_EQ_Aging = SUMX(Item_V,IF(ISBLANK('Item_V'[Vendor Invoice Date]),

DATEDIFF(Item_V[Date In],[IT_Item_Aging_Month_Helper],MONTH),

DATEDIFF('Item_V'[Vendor Invoice Date],[IT_Item_Aging_Month_Helper],MONTH)))

The helper table I created:

Unfortunatly my results cannot be displayed or in other words they stay empty:

What do I miss?

Thank you in advance & happy new year!