Forum Discussion

amirghaderi's avatar
amirghaderi
Icon for Helper IV rankHelper IV
6 years ago

Stop Cumulative count curve

Hi, I have seen a lot post on this subject. but, could not get a clear answer. I have a measure which count a column record, there is a cumulative count measure which I want to stop once it reaches...
Need Help
danextian's avatar
danextian
Icon for Super User rankSuper User
6 years ago

Hi amirghaderi ,


Are you using a separate a date field from a separate Date table in  your graph? You can modify your formula  a bit so the value only shows when ony when the date from a separate table is <= the date from your fact table. Try this.

Issued **bleep**. =
IF (
    LASTDATE ( Dates[Date] )
        <= CALCULATE ( MAX ( 't_MDR2'[Date] ), ALL ( 't_MDR2' ) ),
    CALCULATE (
        [Issued Count],
        FILTER ( ALLSELECTED ( 't_MDR2' ), 't_MDR2'[Date] <= MAX ( t_MDR2[Date] ) )
    )
)

 

amirghaderi's avatar
amirghaderi
Icon for Helper IV rankHelper IV
6 years ago

Hi, Yes I have a table for dates.

I changed the measure as per your note and no chnage to the output.