Add from previous row value in a Matrix

Hey marcss44 ,

 

based on your sample data I use two measures to create the Matrix visual:

1. A measure that does the distinctcount
   Because DISTINCTCOUNT is an expensive operation I use one of the optimization techniques, you can read about optimizing DISTINCTCOUNT here: Analyzing the performance of DISTINCTCOUNT in DAX - SQLBI
2. A measure that creates the RunningSum of the DistinctCounts across the Days
   This measure is still leveraging WINDOW
   
   

The DISTINCTCOUNT measure:

Some kind of DistinctCount = 
COUNTROWS(
    VALUES( 'SDFSDG'[PEDIDO] )
)

The RunningSum measure:

RunningSum Of DistinctCounts = 
[Some kind of DistinctCount]
+
SUMX(
    WINDOW(
        1 , abs
        , -1 , rel
        , SUMMARIZE(
            ALLSELECTED( 'TablaDifDias'[Value] )
            , 'TablaDifDias'[Value]
        )
        , ORDERBY( 'TablaDifDias'[Value] , ASC )
    )
    , [Some kind of DistinctCount]
)

And the Matrix visual:

The screenshot reveals an implicit challenge/isssue of RunningSums calculations. If you do not want to have a running sum calculated for days that do not have DISTINCTCOUNT then you can use the below measure:

smarter RunningSum Of DistinctCounts = 
var currentDistinctCount = [Some kind of DistinctCount]
return
IF( NOT(ISBLANK( currentDistinctCount ) )
    , currentDistinctCount
    +
    SUMX(
        WINDOW(
            1 , abs
            , -1 , rel
            , SUMMARIZE(
                ALLSELECTED( 'TablaDifDias'[Value] )
                , 'TablaDifDias'[Value]
            )
            , ORDERBY( 'TablaDifDias'[Value] , ASC )
        )
        , [Some kind of DistinctCount]
    )
)

 

Hopefully, this provides what you are looking for.

 

Regards,

Tom