Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to Solution.
Good afternoon, I was able to find a solution for it
It is achieved with the following measure
Total line consultation is my sales column
Good afternoon, I was able to find a solution for it
It is achieved with the following measure
Total line consultation is my sales column
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
82 | |
81 | |
52 | |
39 | |
35 |
User | Count |
---|---|
95 | |
79 | |
52 | |
49 | |
47 |