cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Joe_100 Helper I
Helper I

Slicer selection measure for dynamic calculation

Hi all,

 

Please see below the following example:

 

I have a slicer on column period (a month has two periods in this case). If i make a selection on a period i need to see the sales for that specific period only, but i need the budget number over the two periods (month) combined.Somehow i need to filter the budget on a month number based on my first selection.

 

 

So in this case i should see the sales: 14    budget: 35

PeriodSalesBudgetMonth Year
012018P1101512018
012018P2152012018
022018P1142222018
022018P2141322018
032018P1131532018
032018P2211532018
042018P1111042018
042018P2192042018

 

Is it possible to achieve this with a dax formule after i have filtered the dataset based on one period?

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Slicer selection measure for dynamic calculation

@Joe_100

 

May be a MEASURE like this for Budget

 

 

Budget Sum =
VAR myperiod =
    SELECTEDVALUE ( Table1[Month ] )
RETURN
    CALCULATE (
        SUM ( Table1[Budget] ),
        Table1[Month ] = myperiod,
        ALL ( Table1[Period] )
    )
Try my new Power BI game Cross the River

View solution in original post

1 REPLY 1
Highlighted
Super User III
Super User III

Re: Slicer selection measure for dynamic calculation

@Joe_100

 

May be a MEASURE like this for Budget

 

 

Budget Sum =
VAR myperiod =
    SELECTEDVALUE ( Table1[Month ] )
RETURN
    CALCULATE (
        SUM ( Table1[Budget] ),
        Table1[Month ] = myperiod,
        ALL ( Table1[Period] )
    )
Try my new Power BI game Cross the River

View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors