Forum Discussion

Joe_100's avatar
Joe_100
Icon for Helper I rankHelper I
7 years ago
Solved

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!

Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    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] )
    )

1 Reply

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    7 years ago

    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] )
    )