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
  • amirghaderi's avatar
    amirghaderi
    Icon for Helper IV rankHelper IV
    6 years ago

    Hi, thanks for the response. getting closer now. 

    I dont have the option to attached the file.

    I think I cant get the same result since my count data is measure.

    So, assume in your file the value table has three columns, as below. I want to count the cumulative value of "Issued" and "planned" as two curve over the date

    DocumentCriteriaDate
    AIssuedFriday, 19 June 2020
    BPlannedMonday, 8 June 2020
    CIssuedFriday, 26 June 2020
    DIssuedMonday, 8 June 2020
    EPlannedFriday, 5 June 2020
    FIssuedMonday, 8 June 2020
    GIssuedFriday, 26 June 2020
    HIssuedThursday, 11 June 2020
    IPlannedMonday, 15 June 2020
    JPlannedTuesday, 30 June 2020
    KPlannedFriday, 3 July 2020
    LPlannedThursday, 11 June 2020
    MIssuedMonday, 15 June 2020
    • v-yingjl's avatar
      v-yingjl
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi amirghaderi ,

      Try like this measure:

      Issued Count = 
IF (
    SELECTEDVALUE ( 'Table'[Date] )
        <= CALCULATE (
            MAX ( 'Table'[Date] ),
            FILTER ( ALL ( 'Table' ), 'Table'[Criteria] = "Issued" )
        ),
    CALCULATE (
        COUNT ( 'Table'[Date] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Date] <= MAX ( 'Table'[Date] )
                && 'Table'[Criteria] = "Issued"
        )
    )
)

       

      Attached my sample file that hopes to help you: Stop Cumulative count curve.pbix

       

      Best Regards,
      Yingjie Li

      If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

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

        Hi,

        Still the same issue as below: