Filtered Accumulation in DAX

Hi User1245 

Try this one

Test = 
VAR ActualWeek = SELECTEDVALUE(Calendar[Week/Year])
VAR SelectedYear = SELECTEDVALUE(Calendar[Year])
VAR FirstWeekWithData =
    CALCULATE(
        MIN(Calendar[Week/Year]),
        FILTER(
            ALL(Calendar),
            Calendar[Year] = SelectedYear &&
            NOT(ISBLANK(
                CALCULATE(
                    DISTINCTCOUNT('KPI'[PART. NUMBER]),
                    'KPI'[Data] = "Realizado"
                )
            ))
        )
    )
VAR CumulativeValue =
    CALCULATE(
        DISTINCTCOUNT('KPI'[PART. NUMBER]),
        'KPI'[Data] = "Realizado",
        FILTER(
            ALL(Calendar[Week/Year], Calendar[Year]),
            Calendar[Year] = SelectedYear &&
            Calendar[Week/Year] <= ActualWeek
        )
    )
RETURN
    IF(
        ActualWeek >= FirstWeekWithData && NOT(ISBLANK(ActualWeek)),
        CumulativeValue,
        0
    )

If this doesn’t help, could you share an example report (while avoiding confidential data, of course) to better understand your issue?

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.

To report on things that are not there you need to use disconnected tables and/or crossjoins

In your case you need a disconnected calendar table and measures.

Hi User1245,

As per the original post, I tried to come up with a solution. Please check the below attached pbix file.

Filtered Accumulation in DAX.pbix

Please let me know if you have any further questions or need clarifications.

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks! 

Best Regards, 

Maruthi 

LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/ 

X            -  Maruthi Siva Prasad - (@MaruthiSP) / X

Exactly what you want is not clear to me without sample start-state and end-state data. I'll go through a quick example using my own test data, trying to reflect what I can glean are your column names. If the below isn't responsive, please try providing some sample data for us to work off.

Tables:

KPI

Calendar (✓ Mark as date table)

Calendar = 
GENERATE(
    CALENDARAUTO(),
    ROW(
        "Year", YEAR( [Date] ),
        "WeekdayNum", WEEKDAY( [Date], 1 )
    )
)

(snip)

Model:

Visual + Measure:

Assuming that the same PART.NUMBER should only count as 1 across weeks, we can use the following measure.

Part Distinct Count YTD = 
CALCULATE( 
    DISTINCTCOUNT( 'KPI'[PART. NUMBER] ) 
        + IF( NOT ISEMPTY( 'Calendar' ), 0 ), 
    'KPI'[Data] = "Realizado", 
    CALCULATETABLE( 
        DATESYTD( 'Calendar'[Date] ), 
        'Calendar'[WeekdayNum] = 1 
    )
)

Or, if PART.NUMBER repeated in a new week should count as a +1 (ie it's the unique count of parts within each week):

Part Weekly Distinct Count YTD = 
CALCULATE( 
    SUMX( 
        VALUES( 'Calendar'[Date] ), 
        CALCULATE( DISTINCTCOUNT( 'KPI'[PART. NUMBER] ) ) 
    ) + IF( NOT ISEMPTY( 'Calendar' ), 0 ), 
    'KPI'[Data] = "Realizado", 
    CALCULATETABLE( 
        DATESYTD( 'Calendar'[Date] ), 
        'Calendar'[WeekdayNum] = 1 
    ) 
)

Use Calendar fields for the axis (and it appears you want categorical, not continuous, on the x-axis). Here is snip with the first measure.