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

ok, then try

 

    FILTER (
        ALL ( d_StoresAuto ), ALL(YourDateTable), ...

 

 

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

Hi lukiz84 

 

total =
CALCULATE (
    COUNT ( d_StoresAuto[OpeningDate] ),
    FILTER (
        ALL ( d_StoresAuto ),
        ALL( ( d_DateTable )
    )
))
 
The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
 
Displays error