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?