Cumulative values and fill between values

[JeremyJvR]

Hi All,

I need some help with a measure to cumulate values, cut it off at the maximum "Index" value, but still keep fill the values between "Index" values that don't have values.

Basically my table look as follows.

I want the "Blue" lines to fill with the previous value and the "Red" lines to stay blank.

My current Measure looks like this.

IF(FIRSTNONBLANK(MasterValues[Index], MasterValues[Index]) <= max(Pricelist_table[Sort]),

CALCULATE(

    COUNTA('Pricelist_table'[Stock No]),

    FILTER(

        CALCULATETABLE(

            SUMMARIZE('MasterValues', 'MasterValues'[Index], 'MasterValues'[Category]),

            ALLSELECTED('MasterValues')

        ),

        ISONORAFTER(

            'MasterValues'[Index], MAX('MasterValues'[Index]), DESC

    )

)), BLANK())

Context - "Sort" = Lookupvalue of the "Index" column in MasterValues

Thanks in advanced

[amitchandak]

@JeremyJvR , try like

CALCULATE(
COUNTA('Pricelist_table'[Stock No]), filter( allselected('MasterValues'),'MasterValues'[Index]<= MAX('MasterValues'[Index])))

or

IF(FIRSTNONBLANK(MasterValues[Index], MasterValues[Index]) <= max(Pricelist_table[Sort]),
CALCULATE(
COUNTA('Pricelist_table'[Stock No]),
FILTER(
CALCULATETABLE(
SUMMARIZE(allselected('MasterValues'), 'MasterValues'[Index], 'MasterValues'[Category]),
ALLSELECTED('MasterValues')
),
ISONORAFTER(
'MasterValues'[Index], MAX('MasterValues'[Index]), DESC

)
)), BLANK())

[JeremyJvR]

Thanks for the reply.

It almost works, but not yet.

I need it to stop as soon as it hits the maximum, in this case 840.

The issue is that I want to plot this on a line graph against different stock units. It just looks ugly on the graph when those gaps shows

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[JeremyJvR]

https://drive.google.com/file/d/1fomTDJOBem1WpdM3YUgLRuzP1NnLdkXo/view?usp=sharing

Thanks, see if you can reach this?

[Ashish_Mathur]

Hi,

The amitchandak_2 seems just fine to me.  What is the problem?

[JeremyJvR]

Hi,

The issue are the gaps between point where no data is populated. Ideally I would like those gaps filled with a flat line, but not continuing beyond the last point of data.