cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## override slicer value in measure

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 ?

1 ACCEPTED SOLUTION
Super User
``````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.

2 REPLIES 2
Super User

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.

Super User
``````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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors