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.

       

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

        Hi,

        How can I attached PBI file? I cant find any attachment option.