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
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.

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

        Hi amirghaderi ,

        You can upload the sample file to a place where you can store files like Onedrive for Business etc. and share the file link.

         

        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.