Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

A Ramp Up Curve while showing monthly productivity

Hello,

I need to create a cumulative ramp-up curve to display both the total sum of produced units to date and the total sum of produced units per month. The chart below currently shows the number of produced units per month, but I want to create a ramp-up curve.

The measure used to count the rows based on specific criteria from two tables involves the time interval provided by "InstallationStartDate" and "InstallationEndDate."

The measure for showing the total sum of produced units per month is as follows:

Count of finished Skids =
COUNTROWS(
    FILTER(
        Equipment,
                VAR SelectedDisicpline = SELECTEDVALUE(Equipment[CustomText01])
                VAR SelectedActivity = SELECTEDVALUE(ActivtiyLevelProgress[ActivityDescription])
        RETURN
            CALCULATE(
                COUNTROWS(Equipment),
                ActivtiyLevelProgress[ActivityDescription] = SelectedActivity && SelectedDisicpline && ,
                ActivtiyLevelProgress[Progress] = 100 ) && NOT(ISBLANK(Equipment[InstallationEnd])
)))

However, the ramp-up measure is not functioning correctly:

Count of Finished Skids - Ramp Up =
VAR SelectedDisicpline = SELECTEDVALUE(Equipment[CustomText01])
VAR SelectedActivity = SELECTEDVALUE(ActivtiyLevelProgress[ActivityDescription])
VAR StartDate = MIN(Equipment[InstallationStart])  // Find the earliest InstallationStart date
RETURN
SUMX(
    ADDCOLUMNS(
        GENERATESERIES(
            StartDate,   // Start date
            MAX(Equipment[InstallationEnd]),  // End date (based on the latest InstallationEnd date)
            1  // Increment by 1 day
        ),
        "Date", [Value]
    ),
    CALCULATE(
        COUNTROWS(Equipment),
        ActivtiyLevelProgress[ActivityDescription] = SelectedActivity &&
        SelectedDisicpline &&
        ActivtiyLevelProgress[Progress] = 100
    )
)

In simple terms, i want to create a curve that shows the cumulative production over time, considering specific criteria. The challenge is that the "ramp-up" measure is not delivering the expected results.

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Looking forward for your support