topic Re: SUM VALUES FOR THE PREVIOUS ROUND in DAX Commands and Tips

SUM VALUES FOR THE PREVIOUS ROUND

Anonymous — Sun, 13 Oct 2019 09:46:26 GMT

Hello...

I have table employee

which have

ID	VALUE	ROUND
1	10	1
2	10	1
3	10	1
4	20	2
5	30	2
6	20	3
7	20	3
8	20	3

and round table which have

ROUND

how to write dax eqaution to sum values for previous round

eg. output

ROUND	sum	prev sum
1	30
2	50	30
3	60	50

Re: SUM VALUES FOR THE PREVIOUS ROUND

AlB — Sun, 13 Oct 2019 11:39:42 GMT

Hi Anonymous

Measure =
CALCULATE (
    SUM ( Table1[VALUE] ),
    FILTER (
        ALL ( Table1[Round] ),
        Table1[Round] = ( SELECTEDVALUE ( Table1[Round] ) - 1 )
    )
)

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers

Re: SUM VALUES FOR THE PREVIOUS ROUND

Anonymous — Sun, 13 Oct 2019 13:17:31 GMT

thank you for responding...

but ssas doesn't support the function

SELECTEDVALUE

is there any work around ?

Re: SUM VALUES FOR THE PREVIOUS ROUND

AlB — Sun, 13 Oct 2019 15:27:47 GMT

Measure =
CALCULATE (
    SUM ( Table1[VALUE] ),
    FILTER (
        ALL ( Table1[Round] ),
        Table1[Round] = IF ( HASONEVALUE ( Table1[Round] ), VALUES ( Table1[Round] ) - 1 )
    )
)

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers