Change column value based on slicer

[Pat8]

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

Month	This Month	Not This Month	Amount	Measure: Amount - Lastmonth amount
1-Jan	TRUE	FALSE	500	0
1-Feb	FALSE	TRUE	700	200
1-Mar	FALSE	TRUE	400	-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):

Month	Amount	Measure: Amount - Lastmonth amount	New Measure
1-Jan	500		FALSE
1-Feb	700	200	FALSE
1-Mar	400	-300	TRUE

[V-lianl-msft · Accepted solution]

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]

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]

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