override slicer value in measure

[newtopbitoo]

I am very new to power bi and dax, so I thought I start with a simple dax formula.....and failed

I have a table with

year, month,value

I created a slicer with "month"to select"

I want to measures

1. sum of values of selected month

2. sum of values where month <= selected month

Month is a numeric field, so  not a date field.

First calculation is simple but second value gives the same result as 1.

This is my formula:

Cumulative_value = sumx(filter(table, table[month] <= selectedvalue(table[month]))tabel[values])

What am I doing wrong ?

[AlB]

@newtopbitoo 

Or alternatively:

Cumulative_value =
VAR aux_ =
    SELECTEDVALUE ( table1[month] )
RETURN
    CALCULATE ( SUM ( table1[values] ), table1[month] <= aux_ )

It would be better to have dates rather than two separate columns with year and month. That will not work if your data spans more than one year

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[AlB · Accepted solution]

Hi @newtopbitoo 

Cumulative_value =
VAR aux_ =
    SELECTEDVALUE ( table1[month] )
RETURN
    SUMX ( FILTER ( ALL ( table1 ), table1[month] <= aux_ ), table1[values] )

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.