Forum Discussion

alexcatala's avatar
alexcatala
Icon for Helper IV rankHelper IV
2 years ago

Total Count cumulative pr year

Hi,   I am trying to create a total cumulative count of stores per year and quarter.   For some reason, it shows only the amount per year, but it doesn't add the previous figures.   I have trie...
Need Help
lukiz84's avatar
lukiz84
Icon for Memorable Member rankMemorable Member
2 years ago

try ALL instead of ALLSELECTED

  • alexcatala's avatar
    alexcatala
    Icon for Helper IV rankHelper IV
    2 years ago

    Hi lukiz84 

     

    I have tried and still gives me the same outcome

    total =
    CALCULATE (
        COUNT ( d_StoresAuto[OpeningDate] ),
        FILTER (
            ALL ( d_StoresAuto[OpeningDate] ),
            d_StoresAuto[OpeningDate] <= MAX ( d_DateTable[Date] )
        )
    )

     

     

    Any other suggestions?