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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
Cocrodile
Helper I
Helper I

Comulative sum Within Categories

Hi I have this table and I wish I could implement the cumulative function on dax.

------------------------------------------------------------------

-The CAT field is the field with reference to the category

-The WEEK field is the field referring to the week

-The Ticket field is the field with reference to the ticket number

-The CUMULATIVE field is the value I would like to get out in DAX and refers to the cumulative

-------------------------------------------------------------------------

Cocrodile_0-1647593823814.png

 

-------------------------------------------------------------------

 

 

I would need a dax formula to calculate the cumulative.
In this case I only reported week 10 but it should calculate the cumulative sum for each week in relation to the category (CAT field).
Each week I have different categories
A thousand thanks

 

 

 

2 REPLIES 2
amitchandak
Super User
Super User

@Cocrodile , based on what I got

sumx(filter(allselected(Table), Table[Cat] = max(Table[Cat])  && Table[Week] <= max(Table[week]) ), [ticket])

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

I have created the measure but testing it but it doesn't make the cumulative sum it brings me only the values

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors