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