How to create bins based on measures?

Question

Hi everyone,&nbsp;I have created a measure (in fact the community helped me to create this measure!), which will calculate the average age of a batch of vessels at a specific date.&nbsp;Here is the code of this measure.AGE at date = VAR ReferenceDate = SELECTEDVALUE(VESSELS[Date])VAR Result = AVERAGEX (CALCULATETABLE('reference vessels',VESSELS[Date]=ReferenceDate,'reference vessels'[Delivery date]&lt;ReferenceDate,crossfilter(VESSELS[VESSEL],'reference vessels'[VesselName], BOTH)),DATEDIFF('reference vessels'[Delivery date], ReferenceDate , MONTH ))RETURN Result /12&nbsp;What I am trying to do now is to display the number of vessels per age bucket (0 to 5 years; 5 to 10 years...) for this specif date?Is it possible to create a measure?&nbsp;Thanks for your supportStephane&nbsp;

johnt75 · Answer

Have a read of the dynamic segmentation pattern.

Forum Discussion

How to create bins based on measures?

1 Reply

Related content

Help to create DAX Measure

Need help creating a measure

Create tooltip based measure

Create a Measure to Count based on a condition

Create pie chart based on measure