How to aggregate calculated measures

[former_member1306017]

Hello Gurus,

Here is my requirement: I have total shipments for each month for each customer. Some shipments are late (actual ship date-plan ship date). I need to categorize these late shipments into category like 1 day late, 2-3 days late etc (please see below table format that I am trying to get to). In the below table all I have from the model are Customer, dates and if a shipment is late or not or the month

So I create calculated measure for each category using days late obtained from actual ship date-plan ship date assigned value 1.

ex: for 1 day late below is the formula I created and all other categories are created this way. The yellow highlighted columns in Pic 1 are the measures I created.

IF([(actual ship date-plan ship date)<0 AND (actual ship date-plan ship date)>=1,1 ,0)

Then I pulled these calculated measures under measures in the chart (stacked bar chart) but the values are not aggregating . pic 2 is the table i need to achieve

Pic2:

Appreciate any guidance

[William_Yu]

Not seeing pic 2 though.

Have you tried to use show total in row?

[ashutosh_rastogi]

Have you tried creating a measure based dimension using the delay period. Say 0-1 is less 1-10 is medium and 10 and above is high.

And use that dimension in stacked chart.

-Ashutosh