Forum Discussion

Dam's avatar
Dam
New Member
4 years ago
Solved

Problems with accumulative count

Hello,   I've got some problem with this field (accumulative count) :   Z_Cumul_Qtés = CALCULATE (     COUNT ([DOSSIER]),     FILTER (ALL('DATA'[CI_MOIS]),DATA[CI_MOIS]<= MAX(DATA[CI_MOIS])...
Dashboards
  • amitchandak's avatar
    amitchandak
    4 years ago

    Dam , if CI_MOIS is in YYYYMM format

    Z_Cumul_Qtés =
    CALCULATE (
        COUNT ([DOSSIER]),
        FILTER (ALL('DATA'[CI_MOIS]),DATA[CI_MOIS]<= MAX(DATA[CI_MOIS])
        )
    )
     
    or
     
     
    Z_Cumul_Qtés =
    CALCULATE (
        COUNT ([DOSSIER]),
        FILTER (ALL('DATA'[CI_MOIS]),DATA[CI_MOIS]<= MAX(DATA[CI_MOIS]) && DATA[Year]= MAX(DATA[Year])
        )
    )
     
    If this does not help
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Dam's avatar
Dam
New Member
3 years ago

Thanks Amitchandak,

It was the best solution...