Suma aid for months and year

[Syndicate_Admin]

I have a table with 486 Franquicas, in each year or month there are different amounts of Franchises according to their date of entry, but when I want to make the sum per month or year, the table only shows me the total.

In my franchise talve each row equals a franchise, so I tried countrows and SUM. The result is always the same.

[v-easonf-msft]

Hi， @Syndicate_Admin 

What does your current data model look like?
Did you add another calendar table?

Best Regards,
Community Support Team _ Eason

[Syndicate_Admin · Accepted solution]

Hello! Thank you for your answers.

I realized that the problem was my calendar table. there was no right relationship. fixing this fixed the problem

[amitchandak]

@Syndicate_Admin , You need to share the formula

sumx(values('Date'[Year]), [Total Franquicias])