Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

SUM VALUES FOR THE PREVIOUS ROUND

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  R...
Need Help
AlB's avatar
AlB
Community Champion
6 years ago

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  Datanaut

   

Anonymous's avatar
Anonymous
Not applicable
6 years ago

thank you for responding...

but ssas doesn't support the function 

SELECTEDVALUE

is there any work around ?

  • AlB's avatar
    AlB
    Community Champion
    6 years ago
    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  Datanaut