Forum Discussion

Helper 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

Anonymous

Not applicable

2 years ago

Hi alexcatala ,

If I understand correctly, the issue is that you want to total count cumulative per year and quarter. Please try the following methods and check if they can solve your problem:

1.Ensure that you have a proper relationship between Stores Auto table and Date Table.

2.You can use the following DAX formula.

CountOfStores = 
CALCULATE (
    COUNTROWS(d_StoresAuto),
    FILTER (
        ALLSELECTED(d_DateTable),
        d_StoresAuto[OpeningDate] <= MAX(d_DateTable[Date])
    )
)

3.Add a Quarter column to the table.

YearQuarter = 
FORMAT(d_DateTable[Date], "YYYY") & " Q" & FORMAT(QUARTER(d_DateTable[Date]), "")

4.Check that any filters in the report are not interfering with the calculation.

5.You can also view the following link to learn the total by quarters.

Solved: Cumulative total by quarters - Microsoft Fabric Community

Best Regards,

Wisdom Wu

alexcatala

Helper IV

2 years ago

Hi Anonymous

Unfortunately, it doesn't show the cumulative number

I have tried to use the data from the datetable, as you mentioned the relationship between them and also i tried to add a column on the storeauto table and filter through that too.

Same outcome, it doesn't add the figures, just by year.

1st with the datetable filter