topic Re: override slicer value in measure in DAX Commands and Tips

override slicer value in measure

Anonymous — Fri, 23 Dec 2022 15:00:56 GMT

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 — Fri, 23 Dec 2022 17:10:15 GMT

Hi Anonymous

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.

AlB — Fri, 23 Dec 2022 17:13:35 GMT

Anonymous

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.