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