Forum Discussion

Pat8's avatar
Pat8
Frequent Visitor
4 years ago
Solved

Change column value based on slicer

I have a table with months and showing amounts and a measure comparing last month and this month's amount:

MonthThis MonthNot This MonthAmountMeasure: Amount - Lastmonth amount
1-JanTRUEFALSE5000
1-FebFALSETRUE700200
1-MarFALSETRUE400-300


When I select the month for the slicer, I would like to have a measuer or a column to show the following:

if the selected month is xx month, the value should be the [This Month]. If not, the value of [Not This Month].

Example: selected month is February via slicer, the table should show this (new measure picks up not this month from jan and this month value from feb):

MonthAmountMeasure: Amount - Lastmonth amountNew Measure
1-Jan500 FALSE
1-Feb700200FALSE
1-Mar400-300TRUE






Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    Hi Pat8 ,

     

    You need to create a disconnected table as a slicer,

    slicer = DISTINCT('Table'[Month])


    then create the following measure:

    Measure = IF(MAX('Table'[Month])>SELECTEDVALUE(slicer[Month]),TRUE(),FALSE())

     


    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Pat8 ,

     

    You need to create a disconnected table as a slicer,

    slicer = DISTINCT('Table'[Month])


    then create the following measure:

    Measure = IF(MAX('Table'[Month])>SELECTEDVALUE(slicer[Month]),TRUE(),FALSE())

     


    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • vivran22's avatar
    vivran22
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hello Pat8 ,

     

    You may try this:

     

     

    Selected Measure =
    VAR _PrevMonth = PREVIOUSMONTH('Table'[Month])
    VAR _Calc =
    SELECTEDVALUE('Table'[Amount]) - CALCULATE(SUM('Table'[Amount]),PREVIOUSMONTH('Table'[Month]))
    VAR _Check = IF(NOT ISBLANK(_PrevMonth),_Calc)
    RETURN
    _Check
     
    Cheers!
    Vivek

    If it helps, please mark it as a solution
    Kudos would be a cherry on the top 🙂 (Hit the thumbs up button!)
    If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)


    https://www.vivran.in/

    Connect on LinkedIn
    • Pat8's avatar
      Pat8
      Frequent Visitor
      4 years ago

      Thanks for the reply! What I need is the TRUE/FALSE based on the selected month on the slicer.