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:

       

       

      • v-yingjl's avatar
        v-yingjl
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi amirghaderi ,

        Could you please share a sample file for further discussion? Please remember to replace the sensitive information when sharing sample file.

         

        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.