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
jesusssss
Helper II
Helper II

Make a cumulative measure from a divided measure

Hello good day,
I am trying to make a measure to accumulate the value of another measure month by month, the other measure is the following:
divided=DIVIDE([SUM NC],[Sum Amount],0)
I already managed to make accumulated measurements with tables that only had to be added and put this dax language: Accumulated amount from month to month = CALCULATE( SUM('4 - Number of machines ready'[number]), FILTER(ALL(Calendar), Calendar[Date] <= MAX(Calendar[Date]))) but when trying to somehow replicate it in this new case I am not able since I don't know how to make a cumulative measure using a measure already created. I would really appreciate your help, thank you.
1 ACCEPTED SOLUTION

I tried with that measure but it didn't work for me, in the end I managed to do it with this measure

Cumulative month to month Good = TOTALYTD([Split],Calendar[Date])

View solution in original post

2 REPLIES 2
FreemanZ
Super User
Super User

try this:

Measure = 
CALCULATE(
    [divided],
    FILTER(
        ALL(Calendar),
        Calendar[Date] <= MAX(Calendar[Date])
    )
)

I tried with that measure but it didn't work for me, in the end I managed to do it with this measure

Cumulative month to month Good = TOTALYTD([Split],Calendar[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.