Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Syndicate_Admin
Administrator
Administrator

Total Sales by Cumulative Year without the date filter affecting you unless you change the year

Good afternoon.

I need to calculate the total cumulative sales per year, without the date filter affecting that amount.
For example, when I select any date in 2024, it gives me the total of the selected year and no matter what date of the same year is in the filter, however if I change the year in the filter, it gives me the total of that year.
They gave me a measure but it didn't work, I think because the date filter segmenter has the (Date) column generated by the Calendarauto, it is necessary to keep the filter like this.
The current measurement of my sale per year is as follows

Venta x año = CALCULATE ( TOTALYTD( [Ventatotal], Dimcalendario[Date], YEAR(Dimcalendario[Date]) = YEAR(TODAY())))

My date slicer is with the DATE field

1 ACCEPTED SOLUTION
Syndicate_Admin
Administrator
Administrator

Good afternoon, I was able to find a solution for it
It is achieved with the following measure

Asquil_0-1708372943427.png

Total line consultation is my sales column

View solution in original post

1 REPLY 1
Syndicate_Admin
Administrator
Administrator

Good afternoon, I was able to find a solution for it
It is achieved with the following measure

Asquil_0-1708372943427.png

Total line consultation is my sales column

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.