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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
QS7
Frequent Visitor

Cumulated total not working properly with filter

Hi erveryone, 
I have an issue with a Cumulated total measure, the measure is the following :

 

CALCULATE(
	SUM('Sales'[Number of sales]),
	FILTER(ALLSELECTED('Sales'[Date]) ,'Sales'[Date]<=MAX('Sales'[Date])
))

 

The measure is working as long i'm not trying to filter my datas, when i do ( For exemple when i'm filtering on all the sales > 0$, which is always the case ), the measure is not cumulating anymore and results in something like this :

DateNumbers of sales
01/03/202156
02/03/202154
03/03/202178
04/03/202180
05/03/20210
06/03/202165


Does anyone have an idea where the problem might come from ?
Thanks !

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@QS7 , The date you are using should be the date from sales in visual

 

try like

 

CALCULATE(
	SUM('Sales'[Number of sales]),
	FILTER(ALLSELECTED('Sales') ,'Sales'[Date]<=MAX('Sales'[Date])
))

 

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@QS7 , The date you are using should be the date from sales in visual

 

try like

 

CALCULATE(
	SUM('Sales'[Number of sales]),
	FILTER(ALLSELECTED('Sales') ,'Sales'[Date]<=MAX('Sales'[Date])
))

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors