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.
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
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.